Query and Explain output
here. Query must be executed 4022 times, each with a different Strip_ID, while the script processes, adding 4+ minutes to what would otherwise be a ~90-second task. I have (separate) indices defined @ Parent_Table and Parent_ID, in addition to the table's primary key on an auto-incrementing ID. Adding combined indices for those two fields (in each order, just to be safe) did not change MySQL's analysis of the query or improve execution speed.
[more inside]
posted by The Confessor
on May 24, 2013 -
9 answers
I have a MySQL table with about 100,000 items in it. Question about setting up indexes for efficient querying.
[more inside]
posted by maxwelton
on Oct 15, 2008 -
8 answers
MySQL question: Given a table with a datetime column and several additional columns which may or may not be null, is there an easy way to select the most recent previous non-null value of each column given a specific date?
[more inside]
posted by Nothing
on Mar 13, 2008 -
10 answers
SQL Filter: What query can I use to count the number of times a word appears in a text field?
[more inside]
posted by Wild_Eep
on Feb 21, 2008 -
6 answers
