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. 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. 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. 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
Archived
This topic is now archived and is closed to further replies.