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
egory) 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 September 2004 14:23
MAIL PROTECTED]
> Sent: 07 September 2004 14:23
> To: [EMAIL PROTECTED]
> Subject: problems counting the number of returned rows
>
> Hello!
>
> I am having a problem retrieving the number of records matching a certain
> condition from the database.
> I have a large table of
Hello!
I am having a problem retrieving the number of records matching a certain condition
from the database.
I have a large table of about 3 millions records
A simple query like the one below returns me the results
select * use index(category) from books
where category=1 limit 0,10
This query
