Hi Guys,
I'm having the same problem with SQL_CALC_FOUND_ROWS
Any query involving SQL_CALC_FOUND_ROWS takes ages!! All my tables are normalized,
indexed, and optimized and the query uses the indices correctly. Many people
responded to my previous thread (when I though it was a fulltext issue onl
he manual first if
> it's a live system)
>
> Andy
>
> > -Original Message-
> > From: Arthur Radulescu [mailto:[EMAIL PROTECTED]
> > Sent: 07 September 2004 15:03
> > To: Andy Eastham; Mysql List
> > Subject: Re: problems counting the number
age-
> From: Arthur Radulescu [mailto:[EMAIL PROTECTED]
> Sent: 07 September 2004 15:03
> To: Andy Eastham; Mysql List
> Subject: Re: problems counting the number of returned rows
>
> Thanks for the tip! It is much faster now...
> But it still takes about 3 seconds which makes
Thanks for the tip! It is much faster now...
But it still takes about 3 seconds which makes about the same thing like
using count() so this still does not solves the problem
Regards,
Arthur
> Arthur,
>
> Is it faster if you do:
> select SQL_CALC_FOUND_ROWS category use index(category) from boo
Arthur,
Is it faster if you do:
select SQL_CALC_FOUND_ROWS category use index(category) from books
where category=1 limit 0,10
ie change "*" to "category" (which can be read from the index)?
Andy
> -Original Message-
> From: Arthur Radulescu [mailto:[EMAIL PROTECTED]
> Sent: 07 Septemb
