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