Re: Query takes terribly long

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, Indeed, when I use {put,front,putdatetime}, no filesort is used

Re: Query takes terribly long

, 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 database. Hm, I'll let you know

Re: Query takes terribly long

: 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 database. Hm, I'll let you know if I find out what's causing it. If you have any more ideas, please inform me about them! Storing day, month and year in other columns seems

Re: Query takes terribly long

. 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 terribly long Hello Bill, Your explanation gave

Re: Query takes terribly long

before testing your query to be sure) Regards, Jocelyn Fournier www.presence-pc.com - Original Message - From: Dirk Schippers [EMAIL PROTECTED] To: Jocelyn Fournier [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, September 18, 2004 11:53 PM Subject: Re: Query takes terribly long

Re: Query takes terribly long

[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 that, I've discovered that using the key as you said, with the datetime

Re: Query takes terribly long

- 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, Indeed, when I use {put,front,putdatetime}, no filesort is used. But the query is still

Query takes terribly long

Hello, I have this MyISAM table story (52MB): +-+-+--+-+-++ | Field | Type| Null | Key | Default | Extra |

Query takes terribly long

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 FROM story

Re: Query takes terribly long

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

Re: Query takes terribly long

PROTECTED] Sent: Saturday, September 18, 2004 10:25 PM Subject: Query takes terribly long Hello, I have this MyISAM table story (52MB): +-+-+--+-+-+ + | Field | Type| Null | Key | Default

Re: Query takes terribly long

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 Hello, I have this MyISAM table story

Re: Query takes terribly long

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, September 18, 2004 11:37 PM Subject: Re: Query takes terribly long Hello, I