Re: Very Slow Query

2009-08-28 Thread Jia Chen
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 re

RE: Very Slow Query

2009-08-28 Thread John
+44 (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 &qu

Re: Very Slow Query

2009-08-28 Thread Dan Nelson
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.compusta

Re: Very Slow Query

2009-08-28 Thread Jia Chen
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

2009-08-28 Thread Dan Nelson
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; > +---++-++--++-+--

Very Slow Query

2009-08-28 Thread Jia Chen
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

2006-07-21 Thread mos
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 | +--+

Very slow query

2006-07-21 Thread Michael Sutter
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

2004-10-24 Thread Jigal van Hemert
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, > recentHeade

Fwd: Very slow query

2004-10-24 Thread Mike Wexler
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