Fetching 4000 items?

Previous topic

General

Next topic

Author	Message
Jorge estévez	Tuesday 06 October 2009 7:30:37 am Hello, I have uploaded lots of images to Media, each one of them named with a unique product code. There are 4000 images. When I display a product I must fetch images (already uploaded at media) compare the product's code with the image name and show the image at the browser page. Fetching so many images to iterate and compare to the product's name is time and resource consuming. Is there any other solution worth trying? Fetch node where name is CODE-XXXX, as images have unique names? Could something like this be efficient? Any help... thanks! Diseño Web Cuba Web Design Cuba www.elfosdesign.com
Tero Auralinna	Tuesday 06 October 2009 9:19:52 am Attribute filter will do the trick. Something like this {def $images = fetch( 'content', 'list', hash( 'parent_node_id', 51, 'attribute_filter', array( array( 'image/name','=', 'CODE-XXXX' ) ) ) )} NXC Finland - Open Source solutions, Internet marketing and web analytics http://www.nxc.fi http://www.auralinna.fi http://twitter.com/teroauralinna
Gaetano Giunta	Tuesday 06 October 2009 9:31:20 am You might as well consider: - using an object relation(s) attribute to link images to products - add a secondary location to existing images so that they become children of the corresponding products Basically trading editing time for faster access... Principal Consultant International Business Member of the Community Project Board

Author

Message

Jorge estévez

Tuesday 06 October 2009 7:30:37 am

Hello,

I have uploaded lots of images to Media, each one of them named with a unique product code. There are 4000 images.

When I display a product I must fetch images (already uploaded at media) compare the product's code with the image name and show the image at the browser page.

Fetching so many images to iterate and compare to the product's name is time and resource consuming.

Is there any other solution worth trying?

Fetch node where name is CODE-XXXX, as images have unique names? Could something like this be efficient?

Any help... thanks!

Diseño Web Cuba
Web Design Cuba
www.elfosdesign.com

Tero Auralinna

Tuesday 06 October 2009 9:19:52 am

Attribute filter will do the trick.

Something like this

{def $images = fetch( 'content', 'list',
        hash( 'parent_node_id', 51, 'attribute_filter', array( array( 'image/name','=', 'CODE-XXXX' ) ) ) )}

NXC Finland - Open Source solutions, Internet marketing and web analytics
http://www.nxc.fi
http://www.auralinna.fi
http://twitter.com/teroauralinna

Gaetano Giunta

Tuesday 06 October 2009 9:31:20 am

You might as well consider:

- using an object relation(s) attribute to link images to products

- add a secondary location to existing images so that they become children of the corresponding products

Basically trading editing time for faster access...

Principal Consultant International Business
Member of the Community Project Board

eZ debug

Timing:	Jan 30 2025 21:37:53
Script start
Timing:	Jan 30 2025 21:37:53
Module start 'layout'
Timing:	Jan 30 2025 21:37:53
Module start 'content'
Timing:	Jan 30 2025 21:37:53
Module end 'content'
Timing:	Jan 30 2025 21:37:53
Script end

Main resources:

Total runtime	0.0280 sec
Peak memory usage	6,144.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0063	588.0078	151.1953
Module start 'layout'	0.0063	0.0045	739.2031	220.6719
Module start 'content'	0.0108	0.0156	959.8750	997.7734
Module end 'content'	0.0264	0.0016	1,957.6484	33.9922
Script end	0.0280		1,991.6406

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0030	10.5879	14	0.0002
Check MTime	0.0012	4.1587	14	0.0001
Mysql Total
Database connection	0.0010	3.4507	1	0.0010
Mysqli_queries	0.0029	10.2696	3	0.0010
Looping result	0.0000	0.0460	1	0.0000
Template Total	0.0010	3.7	1	0.0010
Template load	0.0008	2.8840	1	0.0008
Template processing	0.0002	0.8025	1	0.0002
Override
Cache load	0.0006	2.0236	1	0.0006
General
dbfile	0.0015	5.3833	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