P
Paul Clement
¤ I notice when the application uses an Access db on my machine (where no
¤ other application access that database) my application does not reach the
¤ maximum pool connection as fast as when I use an Access db on our server
¤ (where many other applications access that database).
¤ Is this because even though my application say has maximum of 100
¤ connections, because other applications access the same database, there may
¤ not be connection available ?
I'm not sure how you're monitoring the application pool but there shouldn't be any difference. The
application pool for the app on your machine will not reflect usage from clients on other machines.
If you're monitoring the Jet Roster, then that's a bit different since it will reflect all the
connections to the database.
Paul
~~~~
Microsoft MVP (Visual Basic)
¤ other application access that database) my application does not reach the
¤ maximum pool connection as fast as when I use an Access db on our server
¤ (where many other applications access that database).
¤ Is this because even though my application say has maximum of 100
¤ connections, because other applications access the same database, there may
¤ not be connection available ?
I'm not sure how you're monitoring the application pool but there shouldn't be any difference. The
application pool for the app on your machine will not reflect usage from clients on other machines.
If you're monitoring the Jet Roster, then that's a bit different since it will reflect all the
connections to the database.
Paul
~~~~
Microsoft MVP (Visual Basic)