Slow ODBC connection on 2003 server

[Theoden]

I have installed XAMPP on a Windows 2003 server. MySQL is working but it is very slow when using ODBC. A query on a 70,000 record table will require 3 seconds normally. When I query using ODBC, the same query takes 21 seconds. this is a very simple query:
select * from customer where last='spelvin';

This is a 2.66 GHz server with 4 GB of memory. I have turned off Apache and the mail server.
buffer_pool_size=16
addl_mem_pool_size=2
log_file_size=5
log_buffer_size=8

Does anyone here know how to troubleshoot this problem?

Thanks in advance.

Bruce

[Theoden]

This problem has been solved. What did help were the following settings:
innodb_buffer_pool_size = 750M
innodb_additional_mem_pool_size = 250M
That got the speed back up to where it should be. My client is happy.

Adding skip-name-resolve did not help this server.

Note: I did add skip-name-resolve to my own (remotely hosted) server and it made a difference. The login time was reduced from 32 seconds to 12-15 seconds.

Submitted in the hope it will help someone else.