If you use Delphi or VB, VC, there are some API program that let you access
MySQL direct. Not worry about ODBC.
Sommai Fongnamthip
At 01:00 7/6/2001 -0700, Van wrote:
>Muhammad Asif wrote:
> >
> > i have a table with 10000 records in MS Access and
> > MySQL with no index in either database.
> > I query both tables from ColdFusion using ODBC datasources and
> >
> > Data from Access took 13sec to display while
> > Date from MySQL took 23sec to come up
> >
> > MySQL seems to be half way slow....????
> > should i use index etc????
> >
> > comments???
> >
>Muhammad:
>
>ODBC is slow in MySQL. Make sure you're using a current MyODBC
>driver. If that
>doesn't help, don't know what to tell you. Many people use straight network
>queries which avoid this overhead. Keep in mind, ODBC was a standard M$
>put in
>place because their desktop OS is ubiquitous. Oracle wouldn't need an ODBC
>layer if M$ didn't have a monopoly on the desktop. There would be better db
>communications interfaces, instead.
>
>Indexing fields you query often is a given. But, you know this, I'm sure...
>
>Regards,
>Van
>--
>=========================================================================
>Linux rocks!!! http://www.dedserius.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
---------------------------------------------------------------------
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