Re: Connector/Net connection performance

[Valere Palhories]

<< Using pretty much the same configuration you mentioned earlier but not using asp. SP2 is not a problem for me. Could it be your network settings/firewall ? >>

Using VB.NET works fine using the Connector/NET. Since ASP.NET and VB.NET can share the same classes, I've built a class which handles opening the DB connection. From VB.NET, the Open statement is instantaneous, using the same class in ASP.NET takes 20-30 seconds to open the connection.

One of my programmers needed to re-install their laptops. I purposely had them only install with only SP1 for XP. Everything else in terms of versions (IIS, ASP.NET, .NET Framework, Connector, etc.) is the same as mine. We are both pointing to the same MySql Server which is running under Windows.

When he opens the project from Visual Studio.NET and runs it in debug mode, it takes between 1 and 3 seconds to open the database. Running the same code in mine takes 20-30 seconds. Keep in mind that we are both running IIS from our individual laptops.

Both laptops are the same brand, with the same amount of memory and firmware revisions. The only difference is that I'm running with SP2 and his in on SP1.

As I said earlier, I turned off the firewall thinking that was the problem, however that didn't have any affect. There's definately something about the combination of SP2 and ASP.NET that is causing this. If I understand your response, you are running ASP (not .NET) under SP2 using the Connector/NET and don't have any issues?