Re: Slow performance on handler `primary` first

[Magdalena G?ska]

I have the same problem with software migration.

In documentation is written that HANDLER is faster than SELECT statement. This sample data show something opposite.

mysql> HANDLER IMZ OPEN;
Query OK, 0 rows affected (0.00 sec)

mysql> HANDLER IMZ READ tw >= (65884,'2007-12-31') WHERE idtw=65884 AND data<='2009-05-12' LIMIT 100;
...
5 rows in set (0.55 sec)

mysql> HANDLER IMZ CLOSE;
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT * FROM IMZ WHERE idtw=65884 AND data BETWEEN '2007-12-31' AND '2009-05-12' LIMIT 100;
...
5 rows in set (0.03 sec)

mysql> SELECT COUNT(*) FROM IMZ;
+----------+
| COUNT(*) |
+----------+
| 529581 |
+----------+
1 row in set (0.00 sec)

Is any solution to make HANDLER queries faster?