Re: ODBC to MySQL

["L. V. Lammert" <lvl@omnitec.net>]

At 04:20 PM 1/20/2005 -0600, you wrote:
>It sounds like you're using Access as your ODBC client. Access does all 
>kinds of things in addition to what a barebones ODBC application might.

Unfortunately, yes.

>It will suck for returning all of the rows cause that's just shovelling 
>tons of data.  It can be used for it but won't be blazing fast.  Parsing 
>the data on the server and using ODBC to transport the information you 
>need is much better.

Unfortunately, not an option - the app is existing, I'm just trying to 
improve the performance.

>Your current problem sounds like the client is trying to just read in the 
>whole table and then work with it or doing a whole bunch of sorts and 
>sequential scans on a lot of data.  If you cannot change client software, 
>you might want to try investigate what's being queries and see if slapping 
>some indexes or rearranging some tables might make a drastic improvement.

Good idea - thanks.

         Lee


-
To unsubscribe, send email to majordomo@silug.org with
"unsubscribe silug-discuss" in the body.