MYSQL :: UnixODBC Perf

Has anyone had much luck with UnixODBC on RedHat Linux. I've recently moved
a 100 Gb MySQL database from Win2000 Server to a RedHat 9 server and installed
UnixODBC to access it. It appears that the performance is dramatically
slower using the same application, pointed to the RedHat server.

The performance of command line queries works as expected on the Linux box.
I have to use ODBC to access the data (unless anyone knows of a SAS Access for
MySQL module in development--hint, hint, nudge, nudge).

View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread

UnixODBC
Has anyone had much luck with UnixODBC on RedHat Linux. I've recently moved
a 100 Gb MySQL database from Win2000 Server to a RedHat 9 server and installed
UnixODBC to access it. It appears that the performance is dramatically
slower using the same application, pointed to the RedHat server.

The performance of command line queries works as expected on the Linux box.
I have to use ODBC to access the data (unless anyone knows of a SAS Access for
MySQL module in development--hint, hint, nudge, nudge).

C++ Wrapper For UnixODBC/MyODBC

I used an odbc-wrapper connectting mysql with unixODBC.
But it didnt work well, often some exception occured.
So I need one new wrapper for unixODBC, it must run stably.