Subject Database Tuning (when to sweep and page size / buffers) IB 5.6
Author loucks@aim.andrews.edu
I have looked through the archives and haven't seen anything that
really answers the question of buffers. Some of the information I
have read on the internet leads me to believe that Interbase will
only allow 64MB to be buffered.

I have a server with 1 GB of mem and a db that is only 600 MB... It
seems to me that if I cached the whole thing, it would be pretty fast
but I need to know if the system limits me to 64MB... (Page size is 8
K).

Also, I know that in previous versions, I should set the sweep
interval to 0 and do it manually but I would like some input as to
whether to do it nightly, weekly, or monthly. I'm not sure what
statistics would be relevant here, but the database is used by a call
center, so there are a lot of inserts, updates and selects, but in
comparison almost no deletes.