Ojects Relation and huge number of objects.

Previous topic

Setup & design

Next topic

Author	Message
laurent le cadet	Monday 11 May 2009 5:47:03 am Hi, I have a "Wine" classe and I want to like it with reciepes via objects relation. Objects relation is very handy and I want to use it like this: - Check boxes list - 1 pre-selected classe Handy because no need to browse while creating objects. At the end there will be about 200 objects which will be concerned by the datatype. Will it be till performant or is there a best method? Best regards. Laurent
André R.	Monday 11 May 2009 12:34:29 pm Should be ok in newer versions, but you might need to override templates in admin so it 1. is UI workable and 2. doesn't get to slow because of to many fetched related objects. PS: limit and offset parameters on related object fetches where added in 4.1 eZ Online Editor 5: http://projects.ez.no/ezoe \|\| eZJSCore (Ajax): http://projects.ez.no/ezjscore \|\| eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription @: http://twitter.com/andrerom
laurent le cadet	Monday 11 May 2009 11:25:58 pm André, This is an eZp 3.10.1 :) So If it becomes too slow, I will change the datatype method to browse. Thanks. Laurent

Author

Message

laurent le cadet

Monday 11 May 2009 5:47:03 am

Hi,

I have a "Wine" classe and I want to like it with reciepes via objects relation.

Objects relation is very handy and I want to use it like this:

- Check boxes list
- 1 pre-selected classe

Handy because no need to browse while creating objects.

At the end there will be about 200 objects which will be concerned by the datatype.
Will it be till performant or is there a best method?

Best regards.

Laurent

André R.

Monday 11 May 2009 12:34:29 pm

Should be ok in newer versions, but you might need to override templates in admin so it 1. is UI workable and 2. doesn't get to slow because of to many fetched related objects.

PS: limit and offset parameters on related object fetches where added in 4.1

eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription
@: http://twitter.com/andrerom

laurent le cadet

Monday 11 May 2009 11:25:58 pm

André,

This is an eZp 3.10.1 :)
So If it becomes too slow, I will change the datatype method to browse.

Thanks.

Laurent

eZ debug

Timing:	Jan 31 2025 00:39:22
Script start
Timing:	Jan 31 2025 00:39:22
Module start 'layout'
Timing:	Jan 31 2025 00:39:22
Module start 'content'
Timing:	Jan 31 2025 00:39:22
Module end 'content'
Timing:	Jan 31 2025 00:39:22
Script end

Main resources:

Total runtime	0.0202 sec
Peak memory usage	4,096.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0046	588.2656	151.2266
Module start 'layout'	0.0046	0.0029	739.4922	220.7188
Module start 'content'	0.0075	0.0115	960.2109	997.8359
Module end 'content'	0.0190	0.0012	1,958.0469	33.9922
Script end	0.0202		1,992.0391

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0022	10.9226	14	0.0002
Check MTime	0.0009	4.5000	14	0.0001
Mysql Total
Database connection	0.0009	4.2574	1	0.0009
Mysqli_queries	0.0017	8.5584	3	0.0006
Looping result	0.0000	0.0495	1	0.0000
Template Total	0.0009	4.6	1	0.0009
Template load	0.0007	3.5698	1	0.0007
Template processing	0.0002	0.9631	1	0.0002
Override
Cache load	0.0005	2.4984	1	0.0005
General
dbfile	0.0013	6.5792	8	0.0002
String conversion	0.0000	0.0247	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