Daniel Putra escreveu:

> Could please sombody help me or point me into the right direction?
>
> By the way: Page size is 4096
>
>
> Hi
>
> Since weeks I try to overcome the exception below ("unable to
> allocate memory from operating system") without success. I tried
> various different settings (also the default one) in firebird.conf
> without much success. The core settings used are:
>
> DefaultDbCachePages = 2048
> MaxFileSystemCache = 524288
> RemoteAuxPort = 8992
> RemoteServicePort = 9002
> LockMemSize = 524288
> SortMemUpperLimit = 134217728
> ConnectionTimeout = 720
> Authentication = Native
> TempDirectories = temp;temp\email;c:\WINDOWS\Temp;c:\WINNT\Temp;
>
> I am using Firebird superserver 2.1.1.17910. All operations are done
> on one single machine P4 2.8 GHz with 1.5 GB RAM
>
> The exception occures during a commission calculation routine where
> 10 000+ queries are executed (mostly select (65%) but also insert
> (15%) and update (10%)). The exception occures always between 30 to
> 60 minutes after start of the routine. We are using beteen 7 and 13
> connections.
>

Do you have BLOBs on the used tables or in variables?


Adriano