Vashti_Ragoonath@ibi.com wrote:
Hi,
Hi thank you for using MonetDB.
I read in the SQL Reference Manual that “The number of concurrent user threads is a configuration parameter.”, but no information on the name or location or how to change it. Nor is there any info on what the default might be.
Indeed, the maximum number of concurrent users is hardwired into the code (currently 64). Any concurrent use leads to a fight for the resources. This means that most (commercial) systems allow large number of users but limit the admission of queries for execution (effective parallelism). It could indeed lead to superlinear degradation of performance, as any resource limited system would show.
I tried running multiple users and noticed that the performance degradation increased dramatically as the load increased. I looked at the Server and SQL manuals without luck.
To understand the impact of your application, you should study its behavior, e.g TRACE SELECT...., to see what queries are causing the problem. regards,Martin
Thanks,
Tah
------------------------------------------------------------------------
------------------------------------------------------------------------------ Return on Information: Google Enterprise Search pays you back Get the facts. http://p.sf.net/sfu/google-dev2dev
------------------------------------------------------------------------
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users