In the last episode (Dec 15), Dave Juntgen said:
> > ext_doc_id is a CHAR type, which means that you may have two rows,
> > "0412625", and "412625", both of which match the expression "WHERE
> > ext_doc_id=412625". MySQL can't use an index because it has to
> > convert each field to a number befor
270
Fax : 260.459.6271
> -Original Message-
> From: Dan Nelson [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, December 15, 2004 11:10 AM
> To: Dave Juntgen
> Cc: [EMAIL PROTECTED]
> Subject: Re: To use Quotes or not to, that's the question.
>
> In the last epis
In the last episode (Dec 15), Dave Juntgen said:
> Could someone please explain to me why the second query below is
> faster then the first query? The only difference between the two is
> that ext_doc_id's value is quoted. Index and column information
> follow and the table being queried contains
Query caching? The second response probably came from the cache.
To be absolutely sure (a.k.a "overkill") that you have no cached results,
you can restart the server between each query. Or, you can use the RESET
QUERY CACHE command to clear your cache without the restart.
http://dev.mysql.com/d
Hi!
Could someone please explain to me why the second query below is faster then
the first query? The only difference between the two is that ext_doc_id's
value is quoted. Index and column information follow and the table being
queried contains approximately 3.5 million rows.
Thanks!
--Dav
On Wednesday 15 December 2004 15:38, Dave Juntgen might have typed:
> Hi!
>
> Could someone please explain to me why the second query below is faster
> then the first query? The only difference between the two is that
> ext_doc_id's value is quoted. Index and column information follow and the
> t
