Very Slow Query

Hi all, One seemingly simple query that joins two tables takes a long time for me. This is my library. mysql show table status from nber1999;

Re: Very Slow Query

In the last episode (Aug 28), Jia Chen said: One seemingly simple query that joins two tables takes a long time for me. This is my library. mysql show table status from nber1999;

Re: Very Slow Query

Thanks for reply! Yes, it is very slow too if I just execute the select ... part. When I run mysql explain extended select a.*, b.assname, b.cname, b.cusip, b.own, b.pname, b.sname from nber1999.pat1 as a inner join nber1999.compusta1 asb on a.assignee=b.assignee; I got

Re: Very Slow Query

In the last episode (Aug 28), Jia Chen said: Thanks for reply! Yes, it is very slow too if I just execute the select ... part. When I run mysql explain extended select a.*, b.assname, b.cname, b.cusip, b.own, b.pname, b.sname from nber1999.pat1 as a inner join nber1999.compusta1 asb

RE: Very Slow Query

(0)7812 451238 Email j...@butterflysystems.co.uk -Original Message- From: Jia Chen [mailto:chen.1...@gmail.com] Sent: 28 August 2009 17:17 To: Dan Nelson; mysql@lists.mysql.com Subject: Re: Very Slow Query Thanks for reply! Yes, it is very slow too if I just execute the select ... part

Re: Very Slow Query

Hi Dan and John, Thanks for your time! You guys are right. I did not index any columns when I created these tables. After I indexed assignee columns in both tables, the select clause runs in seconds. Best, Jia Dan Nelson wrote: In the last episode (Aug 28), Jia Chen said: Thanks for

Very slow query

Hello everbody, I have a table in my MySQL 5.0.22 Server with this columns. +--+--+--+-+-+---+ | Field| Type | Null | Key | Default | Extra |

Re: Very slow query

At 08:10 AM 7/21/2006, Michael Sutter wrote: Hello everbody, I have a table in my MySQL 5.0.22 Server with this columns. +--+--+--+-+-+---+ | Field| Type | Null | Key | Default | Extra |

Fwd: Very slow query

The didn't show up on the list 2 days after posting it, so I'm posting it again. -- Forwarded message -- From: Mike Wexler [EMAIL PROTECTED] Date: Fri, 22 Oct 2004 14:39:49 -0700 Subject: Very slow query To: [EMAIL PROTECTED] The following query: CREATE TEMPORARY TABLE

Re: Very slow query

Although you're not really asking a question, I presume that you want to know why the query is very slow and how you speed it up. The following query: CREATE TEMPORARY TABLE orders.recentClickOrders SELECT recentHeader.transNum, recentClickLog.adRunId, links.letterId,