Re: slow access to MySql Database
From: Chris R. Timmons (crtimmons_at_X_NOSPAM_Xcrtimmonsinc.com)
Date: 11/25/04
- Next message: Raed Sawalha: "RE: Debugging Windows Service"
- Previous message: Ivar: "Re: Controls/Components"
- 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 ]
Date: Thu, 25 Nov 2004 06:42:46 -0800
Jim Lawton <ucan@use.your.initiative> wrote in
news: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,
I'm not sure what the exact problem could be, but here are some
ideas to try on your laptop:
- Turn on ODBC Trace.
Go to Start / Programs / Administrative Tools / Data Sources (ODBC).
Click on the Tracing tab.
- I'm sure MySql also has some kind of tracing or logging facility.
You might want to check into that.
- Turn off System Restore.
I encountered a similar problem with Interbase database files that
have a GDB extension. System Restore will backup files with a
certain extension every time they are modified, which can slow
things down a lot if the file is frequently modified.
The file extensions that System Restore backs up are listed in
FileList.xml, located somewhere under c:\windows. Note that this
file cannot be modified. If it is, Windows will simply overwrite
the changes by refreshing it from the system cache.
-- Hope this helps. Chris. ------------- C.R. Timmons Consulting, Inc. http://www.crtimmonsinc.com/
- Next message: Raed Sawalha: "RE: Debugging Windows Service"
- Previous message: Ivar: "Re: Controls/Components"
- 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
|
