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? Quote Link to comment 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 Quote Link to comment 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... 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.