From: "Joerg Bruehe" <Joerg.Bruehe@stripped>
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
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(*).
__________ Information from ESET NOD32 Antivirus, version of virus signature database 5224
The message was checked by ESET NOD32 Antivirus.