> >Any ideas of what could be causing the varied response time on a simple query >when everything on the server appears to be identical from one run to another? >Are there settings that can be made on the server to tweak response time for a >database/query like this? > [JS] Is it possible that there are locking conflicts? They can produce the kind of behavior you are describing.
>Here are stats on the files involved in the query and the actual query I am >trying to run. Note that the number of receipts with amount >= 10000 is very >smal compared to the total number of records. > >Main: 900,000 records, 500 Mb (886,361 where recordtype = "INDIVIDUAL") > Primary key: id (int) >Receipt: 4,500,000 records, 700 Mb (6,817 where amount <= 10000) > Primary key: id (int) > Indexed on: mainid (int) >Committee: 4,500 records, 600Kb (1,476 where party = "D") > Primary key: id (int) > Indexed on: Comm_id (varchar(6)) > >create temporary table tmp type = heap >select distinct 3 filterid, m.id, "" GroupLevel, 0 GroupCum >from main m >left join receipt r on m.id = r.mainid >left join campaccommon.committee c on r.comm_id = c.Comm_id >where > recordtype = "INDIVIDUAL" > and c.party = "D" > and r.amount >= 10000 > >Returns 294 records. > >Thanks for any insight you can offer. > > - Leo Siefert -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
