RE: Slow Select count(*) - Second Post

Thanks for all your help. This has got the query time down to 5 seconds from 2 minutes!! Much appreciated everyone. Robin -Original Message- From: Tibor Simko [mailto:[EMAIL PROTECTED]] Sent: 20 February 2001 16:46 To: Robin Keech Cc: '[EMAIL PROTECTED]' Subject: Re: Slow Se

Re: Slow Select count(*) - Second Post

Hello > Is there any way to re-write SQL to force the optimiser to use a certain > index? SELECT foo FROM bar USE INDEX baz WHERE ... See the manual at . cheers -- TS - Before posting,

RE: Slow Select count(*) - Second Post

#x27;ll try dropping the q_idx and see what that gives me. Is there any way to re-write SQL to force the optimiser to use a certain index? Thanks again Robin -Original Message- From: Jarmo Paavilainen [mailto:[EMAIL PROTECTED]] Sent: 20 February 2001 15:50 To: Robin Keech Subject: S

RE: Slow Select count(*) - Second Post

e often used in WHERE clauses. Patrick -Message d'origine- De : Robin Keech [mailto:[EMAIL PROTECTED]] Envoyé : mardi 20 février 2001 16:15 À : '[EMAIL PROTECTED]' Objet : RE: Slow Select count(*) - Second Post Thanks for your response, What benefit would that give me? Wo

RE: Slow Select count(*) - Second Post

select against the queue_index take so long? Thanks for your help in advance, Robin -Original Message- From: Patrick FICHE [mailto:[EMAIL PROTECTED]] Sent: 20 February 2001 14:26 To: Robin Keech Subject: RE: Slow Select count(*) - Second Post Hi, What do you think of creating a combined ind

Slow Select count(*) - Second Post

Hi, This is a repost. Can anyone help me? Where can I look for more clues as to why this select is slow? A MyISAMchk will take the database down for too long, so unless I know that it will give me some usefull information I am hesitant to try it. Can anyone please explain the following? I