Localhost vs. remote performance

[Andr Schršder]

I am building an application using VC++ connecting to MySQL 4.1.7 over the C-API.

When I test against the localhost, I get a decent performance. If I connect to a remote server which much larger resources (CPU, memory, etc) I see a huge performance degrade. It seems to be mainly the performance on SELECT statements. I use prepared statements for both SELECT and INSERT.

How can I narrow down even more where this degrade is coming from?
I have tried several remote servers and also readjusted variables without success. I have also tried several different machines as clients with diffferent OSs (2000 and XP).

What takes about 10 minutes on the localhost takes about 6 hours remotely. The queries are not very long and the rows are not either. There is about one insert to about 6 SELECT statements during this process. According to the server stats, it is not the amount of transferred data causing this problem.

Is it maybe that my application is not linked against the necessary libraries properly?
Which libraries should I be linking against for this kind of application? I have tried both mysqlclient.lib and libmysql.lib with no noticable performance change.

Please help!!!