I want to use MySQL in web based
applications. Can u tell what other way i can go except ODBC
if i have to query the database(MySQL) through some scripting
language(ASP,ColdFusion,JSP,Servlet) and have to display results in a web
browser...
Thx in advance for your time
----- Original Message -----
From: "Van" <[EMAIL PROTECTED]>
To: "Muhammad Asif" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, June 07, 2001 1:00 PM
Subject: Re: MySQL too slow....
> 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