in reply to Re^3: Slow script: DBI, MySQL, or just too much data? in thread Slow script: DBI, MySQL, or just too much data?
testDBToMCQDB, which is where we've had the most optimize problems, has 9 columns, a 2-colum primary key, and ~8.5 million rows. It's a MyISAM table, and has four indexes -- the primary key, 2 single-column indices, and one with the same cols as the key, but in opposite order -- these were all created to speed up select statements which were causing problems.
I expect this script to delete something like 40% of the data from each table.
|