Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VS .NET and MySQL

Status
Not open for further replies.
hekot

hekot

Programmer
Jul 30, 2003
3
HK
Hi,

I'm currently developing a VS .NET application with C#. The program, run on Windows, needs to access MySQL which is installed on a linux machine (MySQL 4.0.15a & RedHat 7.2).

I connect MySQL thru ODBC (driver 3.51) and use C#'s system.data.odbc namespace to implement. And the program select about 700 rows from a 100,000 rows table.

However, the performance differs when I ran the same program on both Win2k and WinXP machines. The response is about 1 second for Win2k but about 10 seconds for WinXP.

Are there any VS .NET experts out there to solve this problem?
Thanks in advanced.


Peter
 
Status
Not open for further replies.

Similar threads

E
  • Locked
  • Question
MySQL calculator tools
Replies
0
Views
228
EdZzy
E
lupidol
  • Locked
  • Question
Cannot create new table in mySQL 3
Replies
6
Views
443
lupidol
lupidol
lupidol
  • Locked
  • Question
mysql cannot add rows with "UNION" 1
Replies
5
Views
402
Chris Miller
Chris Miller
penguinspeaks
  • Locked
  • Question
Stored Procedures and triggers
Replies
9
Views
416
penguinspeaks
penguinspeaks
dylim
  • Locked
  • Question
Why MySQL 5.7 is still getting updates
Replies
3
Views
333
spamjim
spamjim

Part and Inventory Search

Sponsor

Back
Top