From: "Joerg Bruehe" <joerg.bru...@sun.com>
Hi!
Octavian Rasnita wrote:
I have tried, but with no difference.
I have changed some indexes and made the queries run faster, but I still
found a problem:
I use a module that does paging and it makes a select(*) and this query
takes a very long time.
I have also tried to do select(id) where the id column is the primary key,
but it runs very slow also.
I have also seen that select(*) with various where conditions is still
very slow.
Is there any trick to make the select(*) queries run faster within an
InnoDB table?
You should accept the fact that 5.1 has improvements over 5.0, some of
them being better optimization resulting in faster execution.
Upgrade the 5.0 installation to 5.1 to profit from the newer version.
I have tried the select(*) with InnoDB under 5.1, but it is still very slow
(dozens of seconds) while with MyISAM is instant. I know that InnoDB works
differently and cannot do that select so fast, but... dozens of seconds is
too much.
I have succeeded to make the main select very fast, but then the select(*)
needed for paging the results is hundreads times slower.
I have also tried select SQL_CALC_FOUND_ROWS and select found_rows() but it
is much slower than a simple select(*).
Thanks.
Octavian
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5224 (20100624) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org