jaymc Posted July 21, 2007 Share Posted July 21, 2007 I have a huge mysql table, it currently contains 2.5 million rows Its used to keep a log of whos vistited whos member profile When I query it by no means is it lagging, perhaps I have it indexed nicely, however, regardless of indexing surely at some point mysql is really going to struggle when dealing with a table of that size How well can MYSQL deal with huge tables? Perhaps in the future I will have to splice it up into seperate tables but Id rather not do that if I can get away with it Anyone have any information? Link to comment https://forums.phpfreaks.com/topic/61112-table-limitations/ Share on other sites More sharing options...
AndyB Posted July 21, 2007 Share Posted July 21, 2007 http://www.mysqlperformanceblog.com/2006/06/09/why-mysql-could-be-slow-with-large-tables/ Lots of information there Link to comment https://forums.phpfreaks.com/topic/61112-table-limitations/#findComment-304128 Share on other sites More sharing options...
wsantos Posted July 21, 2007 Share Posted July 21, 2007 surely is a big one...if it is properly indexed on visitorID, and userID...Distinct would help a lot or perhaps you could index the timestamp and use wildcard for a date range... Link to comment https://forums.phpfreaks.com/topic/61112-table-limitations/#findComment-304217 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.