Big big fecth..??

Saturday 24 October 2009 8:45:39 pm

I have to allow my client to select a node that has many products, once selected I must display a list of all the products within and some of its attributes.

The problem arises when this kind of “fetch” has to deal with so many nodes that the memory gets compromised (I have whole control of apache at the server , but I would like to keep memory used for running scripts not to big) .

I need to know how to deal with a really big fetch even if it takes some seconds or even minutes but in some way I can free memory withing the fetching of groups of nodes or else.

Any Ideas?

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

Monday 26 October 2009 11:28:51 pm

Can you illustrate your example with some numbers? How many nodes do you have to display? Also, won't caching layer take care of the problem (generate once and server from cache later on)?

--
Company: mediaSELF Sp. z o.o., http://www.mediaself.pl
eZ references: http://ez.no/partners/worldwide_partners/mediaself
eZ certified developer: http://ez.no/certification/verify/272585
eZ blog: http://ez.ryba.eu

Wednesday 28 October 2009 4:46:53 am

Hello,

My client, at different offices around the world is populating the site with products, lots of them, at the head office there is a need to know the list of codes of products that are already inserted in a folder-node (and its folder-childs) to be able to compare with the products that they have in their database, reasonable need indeed).

Taking into consideration usability I built a tree of nodes (similar to the ez admin page) that has checkmarks (all nodes with its corresponding checkmark), So the head office admin clicks the checkmark and a button that makes a call to an url using jAVASCRIPT like this one

http://www.thesite.com/index.php/esl/content/view/getdupcode/181

the 181 is added to the url based on the selection of the node in the tree, and the getupcode is a view mode that get's all the product nodes (within the node's tree) and displays them.

Getting all the products takes too much time and memory, thousands of nodes (and still more to come) lies beneath different branches of the selected node.

I tried to page the output as to display 200 products codes from page to page, by doing so

http://www.thesite.com/index.php/esl/content/view/getdupcode/181/(offset)/50

by some reason the pages goes to it's previous state (before selecting and clicking the button) that is

http://www.thesite.com/index.php/esl/content/view/full/181

And displays nothing (not even the information that should be there before the selection and click to the button)

Thanks.

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