Hi David,
Would be it okay to import all the products from say 10-12 merchants all at once with no filtering or no mapping applied? There would be a huge number of products in all at once (100,000 - 500,000 products in one table)
The reason is, is because I need staff to be able to *create categories and for them to be able to create categories they need to be able to search all these products and find matching categories. This will be done by making an admin section that makes queries on this large product table. The staff don't have knowledge of databases / mysql / notepad etc. All creation will be handled within the admin section.
*In my modified pricetapestry all categories, products, product descriptions, product images etc, merchants etc. are added manually. These are then linked to the products via product mapping in the product table for price comparison only.
cheers,
Peter
Hi Peter,
Price Tapestry itself will handle that number of products, but you will start to get into the realms of server and configuration issues and their impact on performance. Please see the following thread which has some discussion and tips on running Price Tapestry with a very large database...
http://www.pricetapestry.com/node/732
Cheers,
David.