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
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
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 about 3 millions records
A simple query like the one below returns
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
To: [EMAIL PROTECTED]
Subject: problems counting the number of returned rows
[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 about the same thing like
using count() so this still
-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 of returned rows
Thanks for the tip! It is much faster now...
But it still takes about 3 seconds which