Re: slow access to MySql Database
From: Cristian Lupu (civanovici_at_yahoo.com)
Date: 11/25/04
- Next message: Jon Skeet [C# MVP]: "Re: how to get ancestor's type?"
- Previous message: Alex: "Re: How good an encryption algorithm is this?"
- In reply to: Jim Lawton: "slow access to MySql Database"
- Next in thread: Jim Lawton: "Re: slow access to MySql Database"
- Reply: Jim Lawton: "Re: slow access to MySql Database"
- Messages sorted by: [ date ] [ thread ]
To: "Jim Lawton" <ucan@use.your.initiative> Date: Thu, 25 Nov 2004 21:21:00 +0200
Hi,
Why use ODBC (the old 3.51) in C#. You can find a free managed
provider (URL http://umn.dl.sourceforge.
net/sourceforge/mysqldrivercs/MySQLDriverCS-n-EasyQueryTools-3.0.16b.
exe) and it's fast.
Best regards
ubik
11/25/2004 9:51:21 AM
Jim Lawton <ucan@use.your.initiative> wrote in message
<tj3bq05bt2cbs7t7rodefq4hvk5epd0fnu@4ax.com>
> I'm not sure where my problem lies, but someone here might have a
suggestion.
>
> I'm developing a .NET web application, (but I don't really) think
that's
> relevant.
>
> I'm running MySQL 4.1.7-nt on my laptop, and I'm accessing it
through ODBC
> (MyODBC-3.51.10-x86-win-32bit).
>
> I already had the application running OK on my desktop, and when I
created the
> same environment on the laptop, retrieving trivial amounts of data
(5 rows) from
> a table is taking 6 seconds. Updates the same. IN otherwords any
table access
> takes 5 or six seconds. (Table only has about twenty rows in it).
>
> I can connect to the database on the laptop from the desktop (i.e -
application
> runs on desktop, retrieves data from laptop - works fine, not
noticeably slower
> than local on desktop.
>
> If I connect the other way - application on laptop, database on
desktop, it runs
> just as slowly as locally.
>
> The effect is the same whether I connect to 127.0.0.1 or via the
machine name.
>
> I don't really know where to look. Any suggestions would be
gratefully
> received...
>
> Jim
- Next message: Jon Skeet [C# MVP]: "Re: how to get ancestor's type?"
- Previous message: Alex: "Re: How good an encryption algorithm is this?"
- In reply to: Jim Lawton: "slow access to MySql Database"
- Next in thread: Jim Lawton: "Re: slow access to MySql Database"
- Reply: Jim Lawton: "Re: slow access to MySql Database"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
