Håkan Elmqvist writes:
> My MySQLGUI running on a Windows system is invariably much slower(typically
> 30 seconds) than a MSAccess database with tables linked with MyODBC to the
> same Linux-hosted Mysql-database (typically less than 1 second) when
> executing the same query over a telephone internet connection.
> Why is that so?
> H
>
> Professor Håkan Elmqvist
> Avdelningen för medicinsk teknik
> Institutionen för medicinsk laboratorievetenskap & teknik
> KAROLINSKA INSTITUTET
> Novum
> 141 57 Huddinge
> Tel 46-8-585 837 55, Fax 46-8-779 55 50
> epost [EMAIL PROTECTED]
> Organisationsno. 01 202100-2973 01
> Vat No. SE 202100297301
MySQLGUI uses native interface, while Access uses ODBC interface and
mysqlgui should be several times faster over slow lines.
This could be simply a chance that when you used mysqlgui lines were
slow.
To accelerate things, turn on use of compression on mysqlgui in
Options dialogue and save it.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.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