Datatype without ezcontnetobject_attribute

«

Previous topic

|

|

Next topic

»

Author	Message
Gernot Rief	Wednesday 04 May 2005 3:28:34 am hi! is it possible to create a datatype without using the ezcontnetobject_attribute table? e.g. using only ezcontentobject, ...version, ..tree and a table for my data. reason: my ezcontnetobject_attribute is getting very big and slows down my queries thx
kracker (the)	Wednesday 04 May 2005 3:54:32 am not that I've ever seen? Still I have heard before (in past threads / which I can't seem to find at the moment) that .... When you really have a lot of attributes per content class, it may be wise to consider breaking the one class into two or more different classes and adding a relationship (related objects perhaps) between the two objects? still, more information might help understand your situation better ... - How many attributes do you have in your class - What are the specs of your web server (memory, cpu, hosting style(dedicated vs vds vs shared vs the rest)) More server power is like throwing hardware at the problem, (which i tend to think (at times) as more cost effective than software) aka you may be pushing the limits not of eZ publish but of eZ publish within the bounds of your current server configuration. //kracker Futurama : A Tale of Two Santas Member since: 2001.07.13 \|\| http://ezpedia.se7enx.com/
Gernot Rief	Wednesday 04 May 2005 4:06:20 am hi! we allredy splitted but did not use related objects but used the (now main object) as the parent node for the remaining objects. our "starting-condition" for ezcontentobject_attributes: 2.500.000 entries estimatet (with the current handle of attibutes): > 7.000.000 entries i really need to get rid of them.....
kracker (the)	Wednesday 04 May 2005 4:31:06 am Gernot, The Parent / Child breakout is also a good alternative. I didn't understand this block of your reply. our "starting-condition" for ezcontentobject_attributes: 2.500.000 entries estimatet (with the current handle of attibutes): > 7.000.000 entries So I'm still wondering how many attributes per class you have ( 25, 50, 400 ??) Knowing how many attributes per class (and what kind of attributes) could help determine the scope of the breakdown. I wager some attribute types are more performance intensive than simpler attributes (textline vs mult-select) For reference, you may wish to post the class definition for your class and it's attributes to see just how big of a class this exactly is... Fyi, exporting your packages via the ezpkg administration is a great way of getting a text output of eZ publish classes. cheers, //kracker Invader Zim - Door to Door Member since: 2001.07.13 \|\| http://ezpedia.se7enx.com/
Gernot Rief	Wednesday 04 May 2005 5:30:20 am hi! explaining the whole class-structure would take some time... ;-) the two numbers(2.5m, 7m) are: number of entries in ezcontentobject_attribute after an initial import of exisiting data-sets and estimated number of entries in 2 years now a class example: -class person: --attribute my_own_person_datatype (72 fields) (60.000 persons x 72 attributes:saved me over 4.3m entries in ezcontentobject_attribute) --8 object_relation_lists (shame on me, but enhanced object relation was not out yet) some of the object_relation_lists consist of objects which also have object_relation_lists as attributes. all in all we have 300.000 objects with 2.5m attributes so my goal is the keep ezcontentobject_attribute as small as possible cause joining and updating in this table is very time-consuming, especially with between 10 and 50 users editing content and therefore: viewcache=disabled
kracker (the)	Thursday 05 May 2005 3:30:23 am I can relate to your frustration. Sadly this is where I begin to tap out. I wonder if a more well versed developer or eZ systems team member might comment on possible solutions to your performance problems with large classes and objects. I still think it's a good that you gave us all a fairly good idea of the scope / size of the situation. Respectfully, //kracker Eyedea & Abilities : Coaches Member since: 2001.07.13 \|\| http://ezpedia.se7enx.com/

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing:	Jan 18 2025 22:27:32
Script start
Timing:	Jan 18 2025 22:27:32
Module start 'layout'
Timing:	Jan 18 2025 22:27:32
Module start 'content'
Timing:	Jan 18 2025 22:27:32
Module end 'content'
Timing:	Jan 18 2025 22:27:32
Script end

Main resources:

Total runtime	0.0203 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0060	589.4844	152.6406
Module start 'layout'	0.0060	0.0032	742.1250	39.4766
Module start 'content'	0.0092	0.0085	781.6016	97.4922
Module end 'content'	0.0178	0.0025	879.0938	38.3047
Script end	0.0203		917.3984

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0028	13.7752	14	0.0002
Check MTime	0.0012	5.8557	14	0.0001
Mysql Total
Database connection	0.0012	6.0481	1	0.0012
Mysqli_queries	0.0020	9.8377	3	0.0007
Looping result	0.0000	0.1032	1	0.0000
Template Total	0.0021	10.2	1	0.0021
Template load	0.0013	6.6042	1	0.0013
Template processing	0.0007	3.5632	1	0.0007
Override
Cache load	0.0007	3.3414	1	0.0007
General
dbfile	0.0003	1.3715	8	0.0000
String conversion	0.0000	0.0340	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs