Get all products...

Author Message

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

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.