Re: slow access to MySql Database

From: Jim Lawton (ucan_at_use.your.initiative)
Date: 11/26/04 

Date: Fri, 26 Nov 2004 08:09:19 GMT

On Thu, 25 Nov 2004 21:21:00 +0200, "Cristian Lupu" <civanovici@yahoo.com>
wrote:

>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.

Thanks ubik - I tried the managed provider from bytefx - but that had its own
problems. In so far as it worked, it displayed the same symptoms as ODBC.
I'll try your suggestion though, thanks for the tip.

Jim

>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

Relevant Pages

  • INSERT or UPDATE Initialization
    ... and by what (ODBC, OLE DB, Jet etc.) ... Thanks Jim, ...
    (microsoft.public.access.forms)
  • INSERT and UPDATE Initialization Execution
    ... and by what (ODBC, OLE DB, Jet etc.) ... Thanks Jim, ...
    (microsoft.public.access.formscoding)
  • Re: slow access to MySql Database
    ... Why use ODBC in C#. ... Jim Lawton wrote in message ... > same environment on the laptop, ... > runs on desktop, retrieves data from laptop - works fine, not ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Accessing MSDE from Unix and OS X
    ... which is only for Win32 machines. ... Besides Peter's suggestion to run DBI::Proxy, or ODBC, note that my module ... simply reports information about your schema, ...
    (perl.dbi.users)
  • Re: Protecting my app from get?
    ... One suggestion stop using ODBC. ... > Microsoft OLE DB Provider for ODBC Drivers ...
    (microsoft.public.inetserver.asp.db)