Use Database

[Alexandar]

use database db1;
use database db2;
use database db3;
....
Duration for this example is 3 second, size of database db1, db2, db3
is 100MB each,
Does anyone know how to speed up this !!!

Win2000SP2, MSSQL 7.0 SP4

[Dan Guzman]

Re: Use Database

Perhaps the database 'auto close' option is on. You can turn this off
with sp_dboption:

EXEC sp_dboption 'db1', 'auto close' false
EXEC sp_dboption 'db2', 'auto close' false
EXEC sp_dboption 'db3', 'auto close' false

--
Hope this helps.

Dan Guzman
SQL Server MVP

-----------------------
SQL FAQ links (courtesy Neil Pike):

http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800

http://www.sqlserverfaq.com

http://www.mssqlserver.com/faq

-----------------------

"Alexandar" <lalexandar@yah oo.com> wrote in message
news:63b68311.0 309171827.29b52 a37@posting.goo gle.com...[color=blue]
> use database db1;
> use database db2;
> use database db3;
> ....
> Duration for this example is 3 second, size of database db1, db2, db3
> is 100MB each,
> Does anyone know how to speed up this !!!
>
> Win2000SP2, MSSQL 7.0 SP4[/color]