Well thanks for making the icons back to 200x200 and adding the What's New.

Well it will certainly save me money in the long run, because I don't have time to sift through every single category to find out what might be older or had been on sale for more than 7 days. What I can't see, I can't buy. Every other site in your market has this feature and I guess will spend more time shopping there.

Lillian, 7000 records should not be enough to limit your customer's choices. I know it sounds like a lot of records to a layman, but as a programmer that uses mySQL on a daily basis with 100's of thousands of records, it's not. However, if given the traffic, you are having server problems at even this low amount, then there are solutions.

One thing our staff came up with to lighten the load, is to derive a flat fixed length text file from the database with only the pertinant information it needs to display. Text files do not have the overhead of an mySQL request and can reduce server load considerably from the display engine. Since you seem to only update the store once a day or so, you could have the database query once and create this file by cron or have a manual creator after you do the update (which I would recommend in case the text file gets out of sync). The part I don't understand is why Rosity would rather limit their customers and lose revenue rather than have programming deal with the issues. We would certainly be in big trouble at work if we were to suggest such a thing.

ShadowWind