Single User v Multi User performance

Posts   
 
    
sparmar2000 avatar
Posts: 341
Joined: 30-Nov-2003
# Posted on: 18-Jul-2009 16:01:47   

Hi

Does anyone know what kind of performance boost (if any!) is achieved if SQLExpress was changed from being Multi User to Single User.

We cannot easily 'figure' this out because our application (unfortunately) uses both LLBL and non-LLBL code – non-LLBL sometime ‘forget’ to close connection and hence the application does not work in Single User mode.

The idea is that if there is a huge improvement that we will spend time and effort converting to LLBL code. Else we live with it and focus on other area’s such as optimising the SQL /SP’s and remove duplicate codes.

Many thanks for your help in advance.

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 20-Jul-2009 02:30:28   

What you mean about "single-user" or "multi-user" (accounts, users, connections)?

David Elizondo | LLBLGen Support Team