Solved

VB.NET / MySQL performance issues

Posted on 2008-10-15
1
406 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
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

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

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

Suggested Solutions

Recently while returning home from work my wife (another .NET developer) was murmuring something. On further poking she said that she has been assigned a task where she has to serialize and deserialize objects and she is afraid of serialization. Wha…
This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…

790 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