The other thing is that I'm running Samabar as a Service, and I read in the Microsoft
docs that need I may need licensing above 10 connections that uses Windows Server
Services. Would Sambar as a service not be regarded as a Windows Server Service?
Michael
>>> [EMAIL PROTECTED] 12/06/02 03:24PM >>>
Michael
What database are you using?
My busiest connection is auth on a 5000 + member site and this is the
cache setting I use (mySQL)
Maximum Used Connections = 200
Minimum Free Connections = 1
Maximum Idle Period = 5
Single Thread = false
Trace SQL = false
Trace Performance = true
Peter
-----Original Message-----
From: "Michael Cook" <[EMAIL PROTECTED]>
To: "sambar List Member" <[EMAIL PROTECTED]>
Date: Fri, 06 Dec 2002 15:00:58 -0500
Subject: [sambar] System Resource Exceeded {01}
> I am getting a "System Resource Exceeded" error message when doing dbms
> stuff using Sambar. Further to my last message on this (quoted below),
> I have changed the dbms caches as such:
>
> Max Connections 100
> Min Connections 1
> Idle Timeout 1 min
>
> These had been previously set at 10, 1, and 10 minutes, respectively,
> but I am still getting "System Resource Exceeded" error messages.
>
> I should could use some help on this.
>
> Running Sambar 5.2 on Win2K Professional.
>
> Thanks
>
> Michael
>
> Quote of previous message
> -------------------------------
> When configuring the Sambar dbms, there are a number of parameters that
> can be tweaked. Some of these offer default values. For example:
>
> Maximum Used Connections = 5 (default)
> What are the issues for increasing this number, and to what limits?
>
> Minimum Free Connections = 1 (default)
> What are the issues for increasing this number, what are the limits,
> and what relationship does this have to Maximum Used Connections?
>
> Maximum Idle Period (minutes) = 10 (default)
> What are the issues for increasing or decreasing this time, what are
> the limits, and what relationship does this have to Maximum Used
> Connections and Minimum Free Connections?
>
> What tweaks can be made in the ODBC administration for page timeout to
> get better performance out of the Sambar dbms configurations?
>
> Thanks for your input.
>
> Michael
> -------------------------------------------------------
> To unsubscribe please go to http://www.sambar.ch/list/
>
>
-------------------------------------------------------
To unsubscribe please go to http://www.sambar.ch/list/
-------------------------------------------------------
To unsubscribe please go to http://www.sambar.ch/list/
-------------------------------------------------------
To unsubscribe please go to http://www.sambar.ch/list/
