asmith Posted December 4, 2007 Share Posted December 4, 2007 according that a mysql table can store infinite rows, how does it effect the speed of the mysql ? and the same for number of tables ? if i have a table with 10,000,000 rows, how much this will effect the speed of mysql reading and processing ? or if i have 100,000,000 tables in one database . ? Link to comment https://forums.phpfreaks.com/topic/80140-solved-mysql-speed/ Share on other sites More sharing options...
Hooker Posted December 4, 2007 Share Posted December 4, 2007 It depends on your query speed, server settings and on the spec's of the server but aslong as you get everything right you should scale out very well. I've just finnished a system that looks up everyone in the UK at every known address for the last ten years consisting over over 680 million records and the avrage look up takes about 5.6 secs (im still tweaking). Link to comment https://forums.phpfreaks.com/topic/80140-solved-mysql-speed/#findComment-406125 Share on other sites More sharing options...
asmith Posted December 4, 2007 Author Share Posted December 4, 2007 oohh good number you said !! btw how much space that 680 million records has consume ? Link to comment https://forums.phpfreaks.com/topic/80140-solved-mysql-speed/#findComment-406131 Share on other sites More sharing options...
Hooker Posted December 4, 2007 Share Posted December 4, 2007 Around about 612gig with packed keys. It does hold quite detailed information though. Link to comment https://forums.phpfreaks.com/topic/80140-solved-mysql-speed/#findComment-406137 Share on other sites More sharing options...
asmith Posted December 4, 2007 Author Share Posted December 4, 2007 hmm what about plain text rows ? for example how much a table with 1 million rows (user information) , about 20 colomns , each colon one sentence would need ? Link to comment https://forums.phpfreaks.com/topic/80140-solved-mysql-speed/#findComment-406142 Share on other sites More sharing options...
Hooker Posted December 4, 2007 Share Posted December 4, 2007 It can vary quite a bit but i'd reserve around 1.5 - 2gig for it, atleast 'till you have a few records in to get a good estimate. Link to comment https://forums.phpfreaks.com/topic/80140-solved-mysql-speed/#findComment-406150 Share on other sites More sharing options...
asmith Posted December 4, 2007 Author Share Posted December 4, 2007 gotcha ! thanks ! been solved! Link to comment https://forums.phpfreaks.com/topic/80140-solved-mysql-speed/#findComment-406166 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.