arrayGen Posted January 4, 2011 Share Posted January 4, 2011 Hello All I have a table with around 9 million records, what would be the best way to work with it ? Thank Quote Link to comment https://forums.phpfreaks.com/topic/223327-what-is-the-best-way-to-work-with-large-tables/ Share on other sites More sharing options...
trq Posted January 4, 2011 Share Posted January 4, 2011 What do you mean exactly? 'Work with it'? 9 million records isn't exactly massive. Quote Link to comment https://forums.phpfreaks.com/topic/223327-what-is-the-best-way-to-work-with-large-tables/#findComment-1154481 Share on other sites More sharing options...
Zojak_Quaguz Posted January 4, 2011 Share Posted January 4, 2011 Yeah, come on now, I'm working with tables with BILLIONS of records! Quote Link to comment https://forums.phpfreaks.com/topic/223327-what-is-the-best-way-to-work-with-large-tables/#findComment-1154667 Share on other sites More sharing options...
arrayGen Posted January 4, 2011 Author Share Posted January 4, 2011 What do you mean exactly? 'Work with it'? 9 million records isn't exactly massive. what would be the best way to take grouped based and sum based readings from it ? can indexes do the trick or is there another way to take fast readings ? Quote Link to comment https://forums.phpfreaks.com/topic/223327-what-is-the-best-way-to-work-with-large-tables/#findComment-1154750 Share on other sites More sharing options...
ignace Posted January 4, 2011 Share Posted January 4, 2011 http://dev.mysql.com/doc/refman/5.1/en/replication.html http://dev.mysql.com/doc/refman/5.1/en/partitioning.html Quote Link to comment https://forums.phpfreaks.com/topic/223327-what-is-the-best-way-to-work-with-large-tables/#findComment-1154887 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.