472,340 Members | 1,810 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,340 software developers and data experts.

Strange lag with C# and MySQL connector

Hello There, I've recently been working on a large project, very database driven, in C# on windows systems, calling a MySQL database on a linux box.
The project is going very well. Except that simple calls that are sometimes instant, will also sometimes take 10 - 20 seconds. If I were to click a button that refreshes a table, 7 times out of 10 it will be instant, the other 3 times it will lag.
Some details...
All computers that are running clients are running windows XP Prof SP2.
The computer I'm developing on is a P4 3.21 with 2g of RAM.
The other client computers (of which there are 6) range down to a AMD 1100 machine with 512Meg of RAM. They are never really all accessing the database at the same time. They all experience about the same range of performance with the database.
The server was a Thecus Yes Box N2100 Debian Linux with MySQL 5.0.24a, but thinking that it might have been the memory constraints of that system causing the lag, I installed a P4 2100 box with 1g of RAM with Debian, lean and mean, and installed MySQL 5.0.32 on it copying the database over...
But the lag situation was the same.
I started writing the software using a connector I was familiar with, mysql-connector-odbc 3.51
Thinking that that might be the problem I changed to MySQL connector .net 5.0.6 which is what I'm currently using.
But the lag situation was the same.
While I am continually refreshing a simple call, say,
Expand|Select|Wrap|Line Numbers
  1. SELECT t1.EmpNo, t1.JobNo, t1.CustomerName, t1.TaskName, t1.Start, t2.EstTime, t2.TotalTime, t1.TaskNo FROM Work AS t1 INNER JOIN Task AS t2 ON t1.JobNo = t2.JobNo AND t1.TaskNo = t2.TaskNo WHERE t1.Fin IS NULL AND t1.State = 'Started'

I can be running a ping at the same time and it won't fluctuate from being <1ms.
I can run heavy calls in MySQL Administrator over and over in rapid succesion without there being any lag.

My connection string is-
Expand|Select|Wrap|Line Numbers
  1. MyConString = "server=;" +
  2. "uid=root;" +
  3. "pwd=pswrd;" +
  4. "database=classic;";

and a normal call is handled like this-
Expand|Select|Wrap|Line Numbers
  1. MySqlCommand cmd;
  2. MyConnection = new MySqlConnection(MyConString);
  3. MyConnection.Open();
  4. cmd = new MySqlCommand();
  5. MyDA = new MySqlDataAdapter();
  6. MyDS = new DataSet()
  7. cmd.CommandText = SQLquery;
  8. MyDA.SelectCommand = cmd;
  9. MyDA.Fill(MyDS);
  10. MyConnection.Close();

but with lots of error handling and stuff.
The IDE I'm using is Visual C# 2005 Express Edition.
The program works fine, and is sweet to use except for this frequent and annoying database lag.

any ideas?
May 31 '07 #1
3 3836
I' m having exactly the same problem. This show up on debian server. I'm using windows mysql server first. There is no lag on the program. But when i start using Debian linux mysql server, strangely somehow if there is some consecutive selects, there are 1-2 seconds lags between selects.

I make every variable same amout with linux and windows server but it is not about these things i think. Because if you use other connector like mysql query browser there isnt any lag. This cames up if you use connector .NET + debian Linux + c# .

Are there anybody except us sees that problem?? Can anybody help us :)
Nov 8 '08 #2
Pls. post some sample code to connect and insert a simple query to connect to MySQL(Sun or Linux) and c# 2.0.
Dec 18 '08 #3
13,262 8TB
There could be several reasons for the slow behavior.
1.) Poor table design
2.) Lack of proper indexing on tables
3.) Inefficient code for both the front-end and back end.
4.) Poor/unreliable network connectivity
5.) Some database connections not being closed.

Some would even say that the list is endless.
Dec 19 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

by: bunnytail | last post by:
Hi All, I am making a Java Applet connects to mysql database, it works well in application mode. When I run it in applet mode, obviously the...
by: JJ | last post by:
I am a newbie to mySQL. I am developing an ASP .net Web site with mySQL as the database (of products), using vb .net 2003. Can anyone point me in...
by: Tracey | last post by:
I have a Mysql database hosted on a remote server. Previously, I could always connect to those databases using the 3.51 ODBC connector and linking...
by: =?Utf-8?B?RGVubmlz?= | last post by:
I have installed MySql and am trying to use it in VB.Net 2003 using the MyOleDb driver. However, from all I can find, MyOleDb only works on VB.Net...
by: Frank Rizzo | last post by:
I've been given a project to work with which involves connecting to MySQL from .NET 2.0 app. I've googled looked and there is a metric ton of...
by: Vague | last post by:
Hello There, I've recently been working on a large project, very database driven, in C# on windows systems, calling a MySQL database on a linux box....
by: sethupnr | last post by:
when i'm using a simple JSP-mysql code it shows some HTTP status 500 error.But simple JSP program without databse is running , Please help how to...
by: shivapadma | last post by:
i want to access mysql database server from jsp program for this i downloaded mysql-connector-java-3.1.14.zip mysql-connector-java-3.1.14...
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
by: CD Tom | last post by:
This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.