9, so you won't ever see the values for 2004-02-29. Maybe you only care
about an approximate result, and none of this matters.
- Original Message -
From: Dirk Schippers
To: Bill Easton
Cc: [EMAIL PROTECTED]
Sent: Monday, September 20, 2004 6:06 PM
Subject: Re: Query takes
Y(putdatetime) <> 29)
ORDER BY putdatetime DESC
LIMIT 0,30
HTH, Bill
== Dirk Schippers wrote: ==
Date: Sun, 19 Sep 2004 18:35:24 +0200
From: Dirk Schippers <[EMAIL PROTECTED]>
To: Jocelyn Fournier <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED]
Subject: Re: Query takes terribl
=1
AND (MONTH(putdatetime) <> 2 OR DAY(putdatetime) <> 29)
ORDER BY putdatetime DESC
LIMIT 0,30
HTH, Bill
== Dirk Schippers wrote: ==
Date: Sun, 19 Sep 2004 18:35:24 +0200
From: Dirk Schippers <[EMAIL PROTECTED]>
To: Jocelyn Fournier <[EMAIL PROTECTED]>
Cc: [EMAIL PR
19 Sep 2004 18:35:24 +0200
From: Dirk Schippers <[EMAIL PROTECTED]>
To: Jocelyn Fournier <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED]
Subject: Re: Query takes terribly long
No,
I'm quiet sure that isn't the case as I am testing the optimized version
of my website on another databas
celyn Fournier
www.presence-pc.com
- Original Message -
From: "Dirk Schippers" <[EMAIL PROTECTED]>
To: "Jocelyn Fournier" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, September 19, 2004 5:49 PM
Subject: Re: Query takes terribly long
Hello,
Indee
ECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, September 19, 2004 5:49 PM
Subject: Re: Query takes terribly long
> Hello,
>
> Indeed, when I use {put,front,putdatetime}, no filesort is used. But the
> query is still very slow.
> It takes about 2 seconds. And again, mysql prefe
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, September 19, 2004 11:55 AM
Subject: Re: Query takes terribly long
Hello,
Sorry to bother you again, but now I have the following, bit more
complicated query on the same table:
SELECT id FROM story WHERE MONTH(putdatetime) = MONTH('2004-09-19&#x
s" <[EMAIL PROTECTED]>
To: "Jocelyn Fournier" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, September 19, 2004 11:55 AM
Subject: Re: Query takes terribly long
> Hello,
>
> Sorry to bother you again, but now I have the following, bit more
> comp
gt;
To: "Jocelyn Fournier" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, September 19, 2004 11:05 AM
Subject: Re: Query takes terribly long
> Hello,
>
> Thanks for the hint!
> With RESET QUERY CACHE, I'm always sure that the cache is empty and with
quot;Jocelyn Fournier" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, September 18, 2004 11:37 PM
Subject: Re: Query takes terribly long
Hello,
I added the index you said, but mysql (yes 4.x) still prefers using the
other index {put,front,topcategory,approvedby}.
And
t;[EMAIL PROTECTED]>
To: "Jocelyn Fournier" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, September 18, 2004 11:53 PM
Subject: Re: Query takes terribly long
Hello,
Now this I don't understand, now the query takes only 0.05s on any of
the two indexes.
I di
lyn Fournier" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, September 18, 2004 11:53 PM
Subject: Re: Query takes terribly long
> Hello,
>
> Now this I don't understand, now the query takes only 0.05s on any of
> the two indexes.
> I didn&#x
rieve the row in the right order directly.
Regards,
Jocelyn Fournier
www.presence-pc.com
- Original Message -
From: "Dirk Schippers" <[EMAIL PROTECTED]>
To: "Jocelyn Fournier" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, Septembe
-pc.com
> >
> >----- Original Message -
> >From: "Dirk Schippers" <[EMAIL PROTECTED]>
> >To: <[EMAIL PROTECTED]>
> >Sent: Saturday, September 18, 2004 10:25 PM
> >Subject: Query takes terribly long
> >
> >
> >
>
data returned. (I assume you're using
MySQL 4.x)
Regards,
Jocelyn Fournier
www.presence-pc.com
- Original Message -
From: "Dirk Schippers" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, September 18, 2004 10:25 PM
Subject: Query takes terribly long
AIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, September 18, 2004 10:25 PM
Subject: Query takes terribly long
> Hello,
>
> I have this MyISAM table "story" (52MB):
>
+-+-+--+-+-+
+
&
No, it doesn't improve the speed. I think that is because almost all
rows in that table are approved.
Are you also convinced that this is a very long time for such a query?
Or is it normal?
Andrew Kreps wrote:
On Sat, 18 Sep 2004 22:25:12 +0200, Dirk Schippers
<[EMAIL PROTECTED]> wrote:
with
On Sat, 18 Sep 2004 22:25:12 +0200, Dirk Schippers
<[EMAIL PROTECTED]> wrote:
>
> with indexes: id = primary, putdatetime, userid,
> {put,front,topcategory,approvedby} and review.
>
> If I want to know the 30 most recently added and approved items, I do
> the following simple query:
> SELECT id FRO
Hello,
I have this MyISAM table "story" (52MB):
+-+-+--+-+-++
| Field | Type| Null | Key | Default |
Extra |
+-+-+--+-+
19 matches
Mail list logo
