Dear all, I recognized that if more than one (big)query is started on the server at the same time (by multiple users) it tends to get extremly slow. Is there any way to avoid this ? Sebastian
Sebastian Sippl wrote:
Dear all,
I recognized that if more than one (big)query is started on the server at the same time (by multiple users) it tends to get extremly slow. Is there any way to avoid this ?
Sebastian, IMO it will be difficult/impossible to answer this question without at least the following datapoints: - how many users? - what kind of query? - is a relational database involved? - if yes, what database adapter is in usage? cheers, oliver
Sebastian Sippl writes:
I recognized that if more than one (big)query is started on the server at the same time (by multiple users) it tends to get extremly slow. Is there any way to avoid this ? Maybe a problem with your database adapter.
There are some that allow other threads to proceed (e.g. mxZODBCDA) and some that do not (e.g. ZODBCDA). Dieter
participants (3)
-
Dieter Maurer -
Oliver Bleutgen -
Sebastian Sippl