On Thu, Aug 21, 2003 at 11:34:00AM -0400, Jesse Sheidlower wrote: > > I'm struggling with speed issues on some queries that > I would have expected to be relatively fast. Perhaps > even more frustratingly, when I've tried to break > these down into their components, they still execute > very slowly. I've looked over all the relevant suggestions > for optimization and so forth, and there's nothing I can > tell that I'm missing. > > An example of a query is to get all the words (the cg.cw > field) in a particular alphabetical range that have been > added in some timespan (the sref.cd field). The cg table > has about 3M rows, and the sref table about 70,000; the > intervening tables are all indexed on the relevant id > fields:
Sorry, I should have added that these queries are being run on MySQL 4.0.10 on a lightly loaded PIII 1.4Ghz with 1GB RAM and fast SCSI drives. Jesse Sheidlower -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]