Hi!
Jerry Schwartz wrote:
I have a pretty simple query that seems to take a lot longer than it ought to
(over 2 minutes).
[[...]]
SELECT
feed_new.new_title AS `New Title FROM Feed`,
prod.prod_pub_prod_id AS `Lib Code FROM DB`,
prod.prod_title AS `Title FROM DB`,
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
-Original Message-
From: Gavin Towey [mailto:gto...@ffn.com]
Sent: Wednesday, May 26, 2010 7:39 PM
To: je...@gii.co.jp; mysql@lists.mysql.com
Subject: RE: Slow query using string functions
Jerry,
Are you sure this is really your explain plan for this query? That's not at
all what I
/ 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
I have a pretty simple query that seems to take a lot longer than it ought to
(over 2 minutes).
Table `feed_new` has a single VARCHAR(255) column, `new_title`, that is an
index.
Table `prod` has many fields: `prod_title` and `pub_id` are both indexes
(VARCHAR).
`feed_new` has 895 records,
using string functions
I have a pretty simple query that seems to take a lot longer than it ought to
(over 2 minutes).
Table `feed_new` has a single VARCHAR(255) column, `new_title`, that is an
index.
Table `prod` has many fields: `prod_title` and `pub_id` are both indexes
(VARCHAR).
`feed_new
