Hi,
I'm porting a D-ISAM application to Mysql. My idea is to emulate ISAM
calls with the HANDLER syntax. But I wish to make sure that performance
will be at least as good as direct ISAM calls. Then I did some tests,
scanning a simple table containing 6000 records with a small C program.
Here are the results :
SELECT * FROM mytable (first time) 7.48s
SELECT * FROM mytable (cached) 0.15s
HANDLER 7.67s
Direct ISAM calls 0.37s
I wonder if it is normal that HANDLER takes so long, and especially that
HANDLER is so slow compared to direct ISAM calls. Do some of you have
experience of HANDLER usage ?
Christophe.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]