on ftp://ftp.mysql.com/pub/mysql/upload/ please find
file perf_test_case.rar (performance test case).
Within RAR archive there are two files:
- perf_test_data.sql.gz -- test case's data (~105M of data)
- perf_test_query.sql -- test case's query
Test have been done on Windows with 4.0.20d and 4.1.3-beta mysql
4.0.20d - ~0.14s
4.1.3 - ~10.61s ( ~ 43 times slower ! )
Hope it could be useful if such results is caused by a bug.
Please excuse me, if you already know about that kind of problems.