What is the fastest way to query a MySQL database over the web?
I currently use the latest MySQL ODBC drivers which work perfectly - but everything is very slow. Even simple queries over tables just doing a simple join can take an age to download the data. Ignoring the speed of the internet connection is there a set of tips or setup procedures that may help speed things up a little? Any help would be greatly appreciated.
I currently use the latest MySQL ODBC drivers which work perfectly - but everything is very slow. Even simple queries over tables just doing a simple join can take an age to download the data. Ignoring the speed of the internet connection is there a set of tips or setup procedures that may help speed things up a little? Any help would be greatly appreciated.