Forums / General / big fetch and time/memory problems
Jorge estévez
Thursday 16 July 2009 10:26:04 am
I need to do a fetch of nodes, about 5000 scatered over a big tree structure of the site just to display th node´s names. I takes very long just to "fetch" them all, and my PC memory gets exhausted.
How can I fetch them not affecting the memory of my PC and speeding up the fetch
Any code that iterates and can help me clean memory...
Any solutions/tips please!
thanks
Diseño Web Cuba Web Design Cuba www.elfosdesign.com
André R.
Thursday 16 July 2009 1:35:51 pm
The best would probaly be to use custom fetch function / template operator (with custom sql).
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
Friday 17 July 2009 8:46:04 am
Thanks,
The operation I am trying to make consumes time, but this operation will not me made often, so time is not a matter at all.
Memory is still my main issue (I am developing under windows and the OS tells me that I am consuming memory resources)
Can I somehow fetch blocks of nodes and in between clean memory and start over again using offset (within the fetch function)?
Any pseudocode I coul use please...
I am trying to avoid a custom fetch.
thanks, jorge
Jean-Luc Nguyen
Wednesday 22 July 2009 2:35:00 am
Hello,
What about using ezfind to do your fetch?http://ez.no/developer/forum/extensions/ez_find/use_ezfind_as_regular_fetch
http://www.acidre.com