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 7 2858
Jim Lawton <uc**@use.your. initiative> wrote in
news:tj******** *************** *********@4ax.c om:
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/
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 <uc**@use.your. initiative> wrote in message
<tj************ *************** *****@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
On Thu, 25 Nov 2004 06:42:46 -0800, "Chris R. Timmons"
<crtimmons@X_NO SPAM_Xcrtimmons inc.com> wrote: Jim Lawton <uc**@use.your. initiative> wrote in news:tj******* *************** **********@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.
Thanks Chris, I'll give these a go - I think the problem does lie with the OS,
because I changes to a native provider, and the symptoms remain the same.
J
On Thu, 25 Nov 2004 21:21:00 +0200, "Cristian Lupu" <ci********@yah oo.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 <uc**@use.your. initiative> wrote in message <tj*********** *************** ******@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
On Fri, 26 Nov 2004 08:09:19 GMT, Jim Lawton <uc**@use.your. initiative> wrote: On Thu, 25 Nov 2004 21:21:00 +0200, "Cristian Lupu" <ci********@yah oo.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.
I'm no further forward with my basic problem, but I can now say that ByteFX
seems much superior to MySQLDRiverCS better BLOB handling, and more intuitive
dates.
I know this is OT here, but completes the thread for the archive ... 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.
On Fri, 26 Nov 2004 08:09:19 GMT, Jim Lawton <uc**@use.your. initiative> wrote: On Thu, 25 Nov 2004 21:21:00 +0200, "Cristian Lupu" <ci********@yah oo.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.
I'm no further forward with my basic problem, but I can now say that ByteFX
seems much superior to MySQLDRiverCS better BLOB handling, and more intuitive
dates.
I know this is OT here, but completes the thread for the archive ... 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 Lawton wrote: On Fri, 26 Nov 2004 08:09:19 GMT, Jim Lawton <uc**@use.your. initiative> wrote:On Thu, 25 Nov 2004 21:21:00 +0200, "Cristian Lupu" <ci********@yah oo.com> wrote: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.
I'm no further forward with my basic problem, but I can now say that ByteFX seems much superior to MySQLDRiverCS better BLOB handling, and more intuitive dates.
... though it is discontinued as ByteFX and is now the MySql .NET
provider (downloadable from MySql.org). The problem with the old ByteFX
driver is that it apparently can't connect with the latest mysql 4.1
version (I couldn't get it to work). DId you manage to get it to connect
to a default install of MySql 4.1.1g (the latest I think) with InnoDB?
It kept complaining that my client was out of date, which is an error
which is displayed when you use new password storage settings and an old
client (which I didn't I downloaded the latest stable client/server from
the website)
FB This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Stuart Mueller |
last post by:
I have a mySQL database, called clients it has a single table called client
with 2325 records in it. It was originally an Access database but I have
exported it to mySQL.
I have created a system DSN that connects fine. the following code works a
treat. I get Connection Successful printed to my browser.
<%
on error resume next
dim adoConn
set adoConn = Server.CreateObject("ADODB.Connection")
|
by: Jesse Sheidlower |
last post by:
I'm struggling with speed issues on some queries that
I would have expected to be relatively fast. Perhaps
even more frustratingly, when I've tried to break
these down into their components, they still execute
very slowly. I've looked over all the relevant suggestions
for optimization and so forth, and there's nothing I can
tell that I'm missing.
An example of a query is to get all the words (the cg.cw
field) in a particular...
|
by: Dan V. |
last post by:
We use dot net, asp.net and iis 5 on a pentium 1.2 GHZ (dual capable - one
in now) and 1 MB RAM and Access 2002.
Our ASP.NET Database queries to MS Access (running locally) are very slow,
(the programmer can't change this)
and they take between 2 - 15 seconds to load a data page -this is even
running locally on the web server. There are multiple web sites on this
server, with not too much traffic.
Our goal is to have 100-200...
|
by: DJJ |
last post by:
I am using the MySQL ODBC 3.51 driver to link three relatively small MySQL
tables to a Microsoft Access 2003 database. I am finding that the data from
the MySQL tables takes a hell of a long time to load making any kind linkage
with my Access data virtually useless.
I have the MySQL driver setup in as a USER DSN. The MySQL data is sitting
out on a server and the Access database is running locally. The network
connection is very...
|
by: D. Dante Lorenso |
last post by:
Trying to use the 'search' in the docs section of PostgreSQL.org
is extremely SLOW. Considering this is a website for a database
and databases are supposed to be good for indexing content, I'd
expect a much faster performance.
I submitted my search over two minutes ago. I just finished this
email to the list. The results have still not come back. I only
searched for:
SECURITY INVOKER
| |
by: VMI |
last post by:
For some reason, the process of retrieving data (about 20 records) from an
Access table that has 400K records to a dataTable is taking over 3 mins. to
complete. Below is my code to connect to the DB and query the table. The
table "audit" primary key is "Line".
Another weird thing (but I guess that's another post) is that, while it's
doing the dataset Fill, my PC is slowed done substantially. But I don't
know why that would happen since...
|
by: timothy.williams |
last post by:
Hi.
I have a Python program that parses a file and inserts records into a
database with MySQLdb. I recently upgraded to MySQL 5.0.8, and now my
parser runs *really* slow. Writing out to CSV files is fine, but when I
try to insert the same records in a MySQL5 database, it slows to a
crawl. Using MySQL 4.1 seems fine. The data seems to be inserted
correctly, it's just really slow.
Has anyone else noticed a similar problem using MySQL5...
|
by: Cheryl Langdon |
last post by:
Hello everyone,
This is my first attempt at getting help in this manner. Please
forgive me if this is an inappropriate request.
I suddenly find myself in urgent need of instruction on how to
communicate with a MySQL database table on a web server, from inside
of my company's Access-VBA application. I know VBA pretty well but
have never before needed to do this HTTP/XML/MySQL type functions.
|
by: grace |
last post by:
i am wondering why my database retrieval becomes too slow...we set up
a new server (ubuntu, breezy badger) machine where we transferred all
our files from the old server.. Our new server uses Asus p5pe-vm
motherboard and an Intel Pentium D 3.0Ghz processor, compared to the
old one where we uses asrock motherboard and AMD Duron. Both has the
same version of mysql installed...
To summarized, both machine has the same configuration except...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |