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

Reply via email to