Subject | Database Tuning (when to sweep and page size / buffers) IB 5.6 |
---|---|
Author | loucks@aim.andrews.edu |
Post date | 2001-06-27T11:59:56Z |
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.
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.