Dave, your addon is amazing, however, i've ripped through it and have sped up a few queries. The biggest problem i've seen so far is the query that assembles the group where clause statement.
You assemble a where clause formated (B_Board = 'BoardName' OR B_Board = 'wee' OR ....)
I tested a different approach which returns
B_Board IN ('Name1', 'Name2', 'Name3')
This approach seems to strip some time from all of the queries that use it .. i'm unsure if it has to do with what i found in the mysql documentation:
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Optimization.html#MySQL_indexesIn reply to:
These WHERE clauses do NOT use indexes:
... WHERE index_part2=1 AND index_part3=2 /* index_part_1 is not used */
... WHERE index=1 OR A=10 /* Index is not used in both AND parts */
... WHERE index_part1=1 OR index_part2=10 /* No index spans all rows */
In any event, the speed difference is noticeable. HTH
