Welcome to WebmasterWorld Guest from 188.8.131.52
Forum Moderators: phranque
Right now there are 25 total products, and the thing is blazing fast. Amazed me. My question is, if I have 500 products, will the speed of the pages loading slow down? And if so, how much?
You never know if what you have built is going to slow down as things increase, even though we try our best to load test and to design scalable systems. It also depends what factors we are taking into account.
Server setup - shared host, dedicated
Traffic to server and/or site
Is the software presently designed to be scalable?
Concerning mySQL, it map tables to files on the hard disk. The larger the file would get, the longer it would needs to load it and hash it.
I think, you can distribute your products into categories and use SQL querries to select only some products from one category and if the number is more than 25 then u can split the list into more pages. In here, mySQL is the fastest in mid size databases and no delay at all comaring to other engines