Re: many similar indexbased selects are extremely slow

> select field1,field2,field3 from mytable where id=XX;

    For instance, on my machine :

SELECT * FROM bigtable with 2M rows WHERE id IN (list of 500 values)

takes 10 ms.