Bonjour mysql!
Tue, 21 May 2002 00:30:38 +0200, tu as dit :
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
> sql,query
> If you just reply to thi
Mon, 20 May 2002 08:26:31 -0500, tu as dit :
> [snip]
>> How many records do you have in each table? And just how fast do you want
>> this query to be? 1.5 seconds may be optimal for a query this large.
> Perhaps
>> the only thing you could do at this point is beef up your server.
> Not
* Fabien Penso
[...]
> Not that large, I got about 8.000 records in each table. I did put the
> body out from the news table, so the news table could be small, and
> news_body which I don't request all the time would be the bigger one.
from your original post:
FROM news_body,news,
Try
[snip]
> How many records do you have in each table? And just how fast do you want
> this query to be? 1.5 seconds may be optimal for a query this large.
Perhaps
> the only thing you could do at this point is beef up your server.
Not that large, I got about 8.000 records in each table. I did p
Hi Jay!
Mon, 20 May 2002 07:45:00 -0500, tu as dit :
> [snip]
> I have just tried this, but it still takes 1.5sec to run the
> select... :-(
> [/snip]
> Fabien,
> How many records do you have in each table? And just how fast do you want
> this query to be? 1.5 seconds may be optimal fo
[snip]
I have just tried this, but it still takes 1.5sec to run the
select... :-(
[/snip]
Fabien,
How many records do you have in each table? And just how fast do you want
this query to be? 1.5 seconds may be optimal for a query this large. Perhaps
the only thing you could do at this point is be
Hi!
Mon, 20 May 2002 21:30:52 +0900, tu as dit :
> Hi, You are look like very tired...
> I have a good idea!!!
> See fellowing line. "alter table TABLE_NAME add index (timestamp
> desc);"
> import point is "index(timestamp desc)". you did not set index of
> timestamp, so your query
