[Rss_Feeds]

I am working on redesigning an ecommerce site with around 15,000 products. I'll be using php/mysql. With so many product pages/searches and upwards of 2000+ visitors a day I am worried about all the hits to the database.I have read messages here and articles elsewhere on optimizing your database queries and utilizing cache. With so many products and queries, though, I wonder if that's a lot to cache and if there will be so many new queries anyway to make that less effective.Instead of all those people hitting the same database, I was also considering writing individual text files to the server for all the variables required for each product (xml feed or php variable settings to include, etc.). Each product page would look for the appropriate file to include based upon the item number that contained all the relevant information.If I was going to write files within an admin tool anyway, I also considered just writing the entire product page into a static html page on the server (or even a php file if I wanted to preserve some of that functionality).If I went with a product data file or generated pages, I'd only be hitting the database on the admin side to create/update those files and the public would hit it for site searches (which would be used frequently with so many products).Should I just stick with mysql queries and trying to optimize that process, or find a work-around with generated data files? Any other alternatives that might be better?Thanks!


To view links or images in this forum your post count must be 1 or greater. You currently have 0 posts.