Forums / Developer / Get all products...
Jorge estévez
Thursday 04 February 2010 12:04:46 pm
Hello,
How can I search all my products (80 000) and display all of them at once with all the attributes... Without going from page to page...(wich could be tedious for so many items)
Is this possible?
or should I access the database directly to search for all the products and make a report, if so (I think this is the valid way to go) I have no idea how to...
Any tips...
The main goal here is that my client needs to have a list of all the information inserted in the site so he can compare with his database (in excel) who is and who is not inserted and to manage and correct errors in the information.
Is there any excel-output extension that I could use?
The site is in ezp 3.10.1
thanks
Diseño Web Cuba Web Design Cuba www.elfosdesign.com
André R.
Thursday 04 February 2010 12:21:06 pm
Use pure SQL, doing it OOP style with fetches will be slow and consume several gigabytes of memory.
Also make sure you add some cache on it, for instance using ezcCache ;)
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