mySQL dataset over VPN [modified]

[programmervb netc]

My company has some centers on a VPN connection and I am wondering if there is a way to slim the dataset... I am already selecting minimal columns and rows. The query gets passed to the server rather quickly but when the data is being passed back it is rather slow. Any help appreciated. EDIT~~~this is a simple query with no joins and a single where and the column in the where is indexed.

Humble Programmer

modified on Friday, April 9, 2010 5:15 PM

[Graham Breach]

If you're only requesting the data you need, there's not much left to play with. Turn protocol compression on if you don't already and see if that helps. There are also some variables[^] you can set that might give better performance. net_buffer_length is probably the most important.