inversesoft123 Posted January 7, 2011 Share Posted January 7, 2011 As we know the total number of hits to database is proportional to the number of page views if page views * queries per page is more than the capacity of your database, then mysql queries may show problem. is there any way to calculate the database capacity ? I googled someone says 128Mb cache is there for mysql. Quote Link to comment https://forums.phpfreaks.com/topic/223708-database-capscity-calculation-queries-per-page/ Share on other sites More sharing options...
jcbones Posted January 7, 2011 Share Posted January 7, 2011 I think that would be limited by the server's memory allocation. The more memory, the more supported users. I think phpBB forums use around 20 queries per page, and some of those are very busy. As far as capacity, the documentation says that there are known databases with 2K tables, and over 5B rows. Quote Link to comment https://forums.phpfreaks.com/topic/223708-database-capscity-calculation-queries-per-page/#findComment-1156366 Share on other sites More sharing options...
BlueSkyIS Posted January 7, 2011 Share Posted January 7, 2011 it also depends heavily on database structure and complexity of the query. Quote Link to comment https://forums.phpfreaks.com/topic/223708-database-capscity-calculation-queries-per-page/#findComment-1156369 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.