News for hackers. Stuff that matters.
Re:MySQL and partitioning tables with millions of rows by dr_strangelove on Sunday January 31, 2010 @03:50PM (#1091062)
if you had an index on device_id there shouldn't be a difference in performance between the original table and the partioned one. the index is used to reduce the rows that need to be scanned so there wouldn't be a full table scan. btw, why do you use a table lock?

There are no comments on this comment yet.