VS2005...Weird Speed Issue
-
Hey guys I'm writing a program in VS2005 using VB.NET...I'm having a very strange issue. I'm running a fairly lengthy process where I show a progress bar and an estimation of the time remaining...when I run my project while VS is open, the process runs at a normal pace, even if i start the process from the bin and not from VS itself...if i kill VS and then run the process, it becomes unbelievably slow, has anyone else had this problem? Any ideas on how to fix it?
Apparently it's not OK to start a bonfire of Microsoft products in the aisles of CompUSA even though the Linuxrulz web site says so
-
Hey guys I'm writing a program in VS2005 using VB.NET...I'm having a very strange issue. I'm running a fairly lengthy process where I show a progress bar and an estimation of the time remaining...when I run my project while VS is open, the process runs at a normal pace, even if i start the process from the bin and not from VS itself...if i kill VS and then run the process, it becomes unbelievably slow, has anyone else had this problem? Any ideas on how to fix it?
Apparently it's not OK to start a bonfire of Microsoft products in the aisles of CompUSA even though the Linuxrulz web site says so
Have you tried running the process, with all antivirus programs unloaded ?
My advice is free, and you may get what you paid for.
-
Have you tried running the process, with all antivirus programs unloaded ?
My advice is free, and you may get what you paid for.
I don't use any anti virus software, I us a disk image that I can dynamically add to, so any time I get a virus or anything of that sort, I just reinstall off of my image...takes about 5 minutes. It almost seems that VS somehow gives .NET processes a boost or something...I'm not sure. It's very strange, but the rate of speed is drastically different when not running VS, so much so that I think it would almost make the program unusable unless VS was running in the background the entire time...The tool is a data transfer program for SQLServer 2005. On average with VS running, it transfers roughly 150 records per second...when i shut VS down, the rate drops to roughly 20 records per second.
Apparently it's not OK to start a bonfire of Microsoft products in the aisles of CompUSA even though the Linuxrulz web site says so
-
Have you tried running the process, with all antivirus programs unloaded ?
My advice is free, and you may get what you paid for.
Hmmm I figured it out...It is because with VS open I also have a live connection to my database...if i leave my connection open instead of closing it each time i have finished transferring data i don't have this issue. seems a little strange considering connection pooling is supposed to help with this, but apparently doesn't help all that much.
Apparently it's not OK to start a bonfire of Microsoft products in the aisles of CompUSA even though the Linuxrulz web site says so
-
Hmmm I figured it out...It is because with VS open I also have a live connection to my database...if i leave my connection open instead of closing it each time i have finished transferring data i don't have this issue. seems a little strange considering connection pooling is supposed to help with this, but apparently doesn't help all that much.
Apparently it's not OK to start a bonfire of Microsoft products in the aisles of CompUSA even though the Linuxrulz web site says so
Generally speaking, when using databases it is always faster to have as few separate calls and as few separate connections to the db as possible. Don't know why, but so I hear, and so I have experienced myself. Good to hear your problem was solved Johan
My advice is free, and you may get what you paid for.