I haven't had a chance to try that, and this might be totally useless information, but to create a clone of the bigger table (CREATE LIKE and INSERT INTO) takes about 12 seconds.
Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com >-----Original Message----- >From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On Behalf Of >Baron Schwartz >Sent: Thursday, May 27, 2010 9:09 AM >To: MySql >Subject: Re: Slow query using string functions > >Jerry, > >On Wed, May 26, 2010 at 5:13 PM, Jerry Schwartz <je...@gii.co.jp> wrote: >> I have a pretty simple query that seems to take a lot longer than it ought >> to >> (over 2 minutes). >> > >I suspect that if you watch Handler_ stats, you'll find that the >EXPLAIN estimate is wrong for some reason and it's accessing many more >rows than you think in the second table, or something similar. In any >case, I'd start by measuring what the query is actually doing, not >what EXPLAIN thinks. What does that show? > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/mysql?unsub=je...@gii.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
