OBDC's strength is that it is almost universal in accessing files, not
speed, and that may be the reason why using the jet engine will produce
quicker results. I don't know if it will work on your end, but I moved from
using MyOdbc to the following statement in accessing mysql database:
strConnection =
"driver={MySQL};server=localhsot;uid=username;pwd=password;database=databasename"
I use that in my asp applications.
At 06:02 AM 2/9/2001, Quickling wrote:
>Hi,
>
>Question 1:
>---------------
>We've got a server app that does a lot of 'small' database reads and
>writes. We were originally using MS Access via DAO (Jet Engine) and we
>wanted to tighten up DB performance, so we've written a general ODBC
>database wrapper object, but mainly just to connect to MySQL. I figured
>there'd be ODBC overhead, but its a lot worse than I imagined.
>
>I want to know: does it make sense that our original system, connecting
>via 'Jet-engine' to Access, is actually much faster than connecting to
>MySQL via ODBC? This seems to be what's happened.
>
>I'm wondering if it has to do with the overhead of connecting to a
>server-based database via a tcp socket (even on localhost) rather than the
>direct-to-disk Jet engine; maybe because we do so many small reads/updates
>it's actually faster with Access? Any thoughts? Is it worth my time to
>look into using MySQL directly instead of thru ODBC?
>
>I'm obviously working on Windows (NT), connecting at ODBC version 2.0 to
>MySQL server 3.23, using a database converted directly from Access to
>MySQL using the cool (but unstable) DBTools GUI, which kindly retained all
>keys and indexes (which have been reviewed for speed).
>
>
>Question 2:
>---------------
>Is there any way in MySQL to compute, inline SQL, the difference between
>two datetime values? I couldn't find a function which could do anything
>but subtract intervals from datetimes... what I need is the interval!
>
>
>Many thanks in advance,
>
>Jesse
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
*************************
Jonor Lacuesta
Systems Administrator
Philippinemail.com
"Send free postal letters to the Philippines FREE"
http://www.philippinemail.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php