I have my VB.Net 2010 win form app running a job on a table (35.000 rows).
I read from an MS-Access Database and, while iterantig on an OleDbDatareader, I write to the SQL Server Express 2008R2 using SqlDbCommand.ExecuteNonQuery.
A progress bar on the GUI shows the current row.
I've noticed that, while the app is running, if I launch the SSMS and I perform an operation (i.e. a simple select on a table) against the same db, the application goes much more faster. As I close the SSMS, the application slows
down. All this is running on the same PC.
In both, application and SSMS, the SQL Server Server Authentication is used (same user). Here is the connection string, stored into the app.config file:
<add name="DB" connectionString="Data Source=localhost\sqlExpress;Initial Catalog=myDb;Integrated Security=False;User ID=myUser;Password=myPass;pooling=False;Connection Timeout=1200;"/>
Any idea ?
thanks in advance.
View Complete Post