Hi Alan

How can I check the Charset. Is by extracting Metadata or is there an easy way (command tools) to check and change the Charset in the database?

Kennneth

--- In firebird-support@yahoogroups.com, "Kenneth S. Tilsted" <kst@...> wrote:
>
> Hi Alan and Helen
>
> When I select in the MON-tables i Can see that all activity in the
> ATTACHMENT gives me a characterset of value 0. I suppose that indicates
> everybody is using the same charset.
>
> I have tried to set DefaultCache pages to 50 and 150 - same symptom. Also
> with the lochHashSlot set to 2039.
>
> When I open my application its rapidly increases to 95Mb and if I use
> another function its just increasing the use of memory.
>
> I have now tried the Firebird.Conf:
> as standard - same symptom
> DefaultCachePages to 50, 128, 150, 512, 1024, 2048 - same symptom.
>
> the Database has a page size of 8192.
>
> Please advice, what to do next. Are running out of ideas. Is there any
> settings server side on windows to set maximize each process Menory use? Or
> on the Firebird Server itself?
>
> For each change I have just restarted the Firebird Service and made a
> "taskkill /F IM fb_inet_server.exe /T". Is it necessary to restrat whole
> server for each change?
>
> thanks for any help provided.
>
> Kenneth
>
>
>
> 2010/6/28 Kenneth Tilsted <kst@...>
>
> > Hi Alan and Helen
> >
> > When I select in the MON-tables i Can see that all activity in the
> > ATTACHMENT gives me a characterset of value 0. I suppose that indicates
> > everybody is using the same charset.
> >
> > I have tried to set DefaultCache pages to 50 and 150 - same symptom. Also
> > with the lochHashSlot set to 2039.
> >
> > When I open my application its rapidly increases to 95Mb and if I use
> > another function its just increasing the use of memory.
> >
> > I have now tried the Firebird.Conf:
> > as standard - same symptom
> > DefaultCachePages to 50, 128, 150, 512, 1024, 2048 - same symptom.
> >
> > the Database has a page size of 8192.
> >
> > Please advice, what to do next. Are running out of ideas. Is there any
> > settings server side on windows to set maximize each process Menory use? Or
> > on the Firebird Server itself?
> >
> > For each change I have just restarted the Firebird Service and made a
> >
> > taskkill /F /IM fb_inet_server.exe /T
> >
> > Is it necessary to restrat whole server for each change?
> >
> > thanks for any help provided.
> >
> > Kenneth
> >
> >
> > Alan McDonald skrev:
> >
> >>
> >> > Hi all Firebird friends
> >> >
> >> > Have posted this one as well on DEVSHED.COM <http://devshed.com/> but
> >> so far no help
> >> > received. Will try this forum
> >> >
> >> > I have a weird problem. A Firebird 2.1.3 Firebird classic database at
> >> > customer site where the fb_inet_server.exe process eats up all memory
> >> > on server and then continues to use swap file until server crashes.
> >>
> >> are all users conneccting using the same CHARSET? There is a bug in
> >> 2.1.3/4
> >> associated with BLOB memory. I am using 2.1.4 snapshot with no issues like
> >> this anymore.
> >> Alan
> >>
> >> >
> >> > I have many customers with same application but i have only seen this
> >> > at 1 customer site. Normally a process will take up between 25-40Mb of
> >> > Ram each, but at this customer it is up to 130Mb each process. Its like
> >> > it is not freeing up the memory
> >> >
> >> > The configuration is the same - standard for the databaseserver
> >> > installation. The OS is Windows 2003 Std. Edition SP2.
> >> >
> >> > What am I looking for in order to find out why the processes consumes
> >> > so much memory?
> >> >
> >> > The server has 2xdual core processor. The CPU seems to be OK - around
> >> > 20-40% of load.
> >> >
> >> > It is a new created VMWare instans with 4Gb of Ram but the problem was
> >> > exactly the same on a physical server before the change to VMWare.
> >> >
> >> > Am I looking at Firebird Database Enigine, The database itself or the
> >> > OS?
> >> >
> >> > Can anyone in here help - what info more can I Provide to you.
> >> >
> >> > Thanks in Advance
> >> >
> >> > Regards
> >>
> >>
> >>
> >
> >
> >
>
>
> --
> Mvh
> Kenneth Tilsted
> Support- & Driftschef
>
> Avaleo ApS
> Skagensgade 39, 2
> 2630 Høje-Tåstrup
> Tlf - Kontor: 70104488
> Tld - Direkte: 61550076
>
>
> [Non-text portions of this message have been removed]
>