Accessing database blocks other users

[riksweeney]

If a user runs a query that takes a long time no other user can run a query until the first one returns. Is there something I need to do in SilverStream's setup to allow more than one user to access the database at a time?

Thanks

Richard Sweeney

 

[jwenting]

What are your database settings?
If you have set too small a number of allowed database connections either in Silverstream (check the SMC) or the database engine itself clients may have to wait for connections to be freed before they can use them.

Another possibility might be that you have set the class performing the query to be static in which case only one client at a time can use it.