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 . ? Quote Link to comment 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). Quote Link to comment 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 ? Quote Link to comment 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. Quote Link to comment 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 ? Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
asmith Posted December 4, 2007 Author Share Posted December 4, 2007 gotcha ! thanks ! been solved! Quote Link to comment 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.