Good point. The mySQL databases that I connected to were very small so I never encountered server-side issues. I do recall tat there were a couple of settings in the ODBC Manager that I had to set which made a big difference - I had the similar experience with an Oracle ODBC connection just a few months ago.
>Or some indeces. Or more memory for the db server. Or some other optimization.
>
>>The ODBC should be fine. If you are having a performance problem then the ODBC setting may not be correct or maybe the SQL statements are pulling too many records ??
ICQ 10556 (ya), 254117