How about PhP? Simon -----Original Message----- From: Muhammad Asif [mailto:[EMAIL PROTECTED]] Sent: 07 June 2001 10:19 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: MySQL too slow.... 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 --------------------------------------------------------------------- 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
