Solved

VB.NET / MySQL performance issues

Posted on 2008-10-15
1
412 Views
Last Modified: 2012-06-21
I have been trying to use VB.NET & MySQL together but notice that performance is quite poor... is this normal?

For instance, I can execute 4000 insert queries in phpmysql rather effortlessly however trying to do the same thing in VB.NET takes a long time & uses quite a bit of resources.

My question is, are .NET applications capable of performing MySQL queries with the speed of web applications written in languages such as PHP?
0
Comment
Question by:mcainc
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 1

Accepted Solution

by:
Abh4IT earned 500 total points
ID: 22729343
Hi,

This is quite normal I guess since you might be using ODBC Data Adapters to access mySQL. I am not aware of any .NET Native adapters available for the case. So it normally takes long time.My feeling is if mySQL is the choice PHP is better language together with it. As well there are some constraints wrt MYSQL wrt to profressional application development like it doesn't support RollBack/Transactions(At least a year earlier). So PGSQL is a better alternative if you really want an opensource one. This is more mature and supports transactions.

Hope this helps
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Summary Displaying images in RichTextBox is a common requirement with limited solutions available. Pasting through clipboard or embedding into RTF content only support static images.  This article describes how to insert Windows control objects int…
For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question