.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,
>-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
Jerry,
On Wed, May 26, 2010 at 5:13 PM, Jerry Schwartz 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 m
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
query 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).
`fee
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, `pr
