Subject RE: [firebird-support] Re: Large Firebird 1.5 database
Author Leyne, Sean
Gerhard,

> i think large is a relatively value. We have 24 Table, one view, 63
> triggers and 33 procedures. Is this large ?! I don't know, but i
> think is not too large.

Not large at all.


> But we have a lot of traffic which you hav'nt normaly on other
> applications. Some time on the day we store 3-5 documents per second
> and all over the day we are storing 6000-7000 documents.

I still can't see how this would add up to 2GB.

What are your config file settings for:

DefaultDbCachePages
SortMemBlockSize
SortMemUpperLimit

What is your DB setting for Cache size?


Sean