ow that better than any of us.
>
> A query like this should take no longer than 0.1 seconds to execute in
most
> cases, even with a few gigs of data.
>
> Doonny
>
> > -Original Message-
> > From: news [mailto:[EMAIL PROTECTED] On Behalf Of Rob Keeling
&
ailto:[EMAIL PROTECTED] On Behalf Of Rob Keeling
> Sent: Thursday, December 23, 2004 11:55 AM
> To: mysql@lists.mysql.com
> Subject: Optimising a query on a large table.
>
> I have a 152MB MyISAM table that I am trying to execute a simple select
> statement on,
> I need to
Hi Rob!
Am Don, 2004-12-23 um 18.54 schrieb Rob Keeling:
> I have a 152MB MyISAM table that I am trying to execute a simple select
> statement on,
> I need to retreave all rows with a given index, sorted by date.
>
> This is taking a very long period of time to execute.
Can you give the time
"kernel" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Rob,
> Have you run "show full processlist;" to see if it is copying to a tmp
> table ??
>
> walt
Nothing listed other than the query itself. Should have said its on Mysql
3.21.
Rob Keeling
--
I love deadlines. I love the
Rob Keeling wrote:
I have a 152MB MyISAM table that I am trying to execute a simple select
statement on,
I need to retreave all rows with a given index, sorted by date.
This is taking a very long period of time to execute.
What can I do to speed up the query.
The sql is,
SELECT * FROM table WHERE
I have a 152MB MyISAM table that I am trying to execute a simple select
statement on,
I need to retreave all rows with a given index, sorted by date.
This is taking a very long period of time to execute.
What can I do to speed up the query.
The sql is,
SELECT * FROM table WHERE (person_id LIK