mjarsaniya (11/17/2009)
i think using different database per user should give performance because it has separate datafile and logfile but update takes 14.85 minutes which is more than single database 10.12 minutes.
Not really, unless those files are on separate physical drives.
You're possibly seeing locking.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability