Hi Roland,

We use the latest version 1.5 R8

I will turn off the sweep interval and test it.

I just noted today that if I run my App with a wrong table definition (like
including 1 field that does not exists in the DB), then the APP crashes,
and the allocated memory on the firebird server jumps up 300Meg, and that
migth be the case I was suspecting. I mean, whatever goes wrong with 1
connection generates a problem for the full database server, and it looks
like it can not recover itself, unless restarting. ONE IMPORTANT COMMENT:
Looking into the task manager, in processes, Firebird was using only 250 Meg
ram, but the total allocated memory for the server was 650 Meg, and all the
other processed toghether were using only 120 Meg, so I belive Firebird
Failed to release that memory, but for some reason the task manager does not
show it allocated to Firebird. Very Strange!

I only run Firebird on that server (Win 2k Adv. Server), so it could not be
anything else.

Many thanks
Fabian.

----- Original Message -----
From: "Roland Volkmann" <r.volkmann@...>
To: <firebird-support@yahoogroups.com>
Sent: Thursday, January 08, 2004 4:24 AM
Subject: Re: [firebird-support] Superserver on Win2K becames too


> Hello Fabian,
>
> > We use Superserver on Win 2k, from time to time (almost
> > every day) the server starts consuming more processor, and
> > the response time becames too slow.
>
> [snip]
>
> > We have:
> > PIII 800mhz, SCSI UW2, Superserver, 640Mb ram, Only
> > 1 Database with less than 300Mb size. All 40 clients are
> > Windows (NT Workstation or 2K or 98) , within a Lan 100Mb
> > and we use EasySoft ODBC for Firebird.
>
> which version of Firebird do you use?
>
> What is the actual sweep interval? - I propose to set it to 0 (disable)
for a while to
> make sure that it's not the garbage collector disturbing you.
>
>
> With best regards,
>
> Roland.
>
> --
>
> Dipl.-Ing. Roland Volkmann
> IPRO GmbH - Technik
> Steinbeisstr. 6
> D-71229 Leonberg
>
> Tel: +49 7152 9333-0
> Fax: +49 7152 9333-40
>
>
>
>
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to:
> http://docs.yahoo.com/info/terms/
>
>