Subject RE: [firebird-support] RE: Table update performance dropped significantly within few days.
Author

We have even restarted the computer and even a backup and restore. So no way we can have old record versions and the database sill slow.
The slow down is due to hard disk usage.
I tought when are much records and much indices when a record is updated there is no room for recalculate the indexes.
When there is no room more pages must be fetched from disk to ram to recompute the indexes. It increases hdd usage and dramatically slow down.
This happens from one time to other with no changes in system or database.
When you increase database caches Firebird haves enought room to recompute all indexes with a minimum hdd usage and so very fast, very!
As I sayd other "solutions" are reducing record numbers or deleting indexes.

Em 15/01/2014 18:23, "Evelyne Girard" <egirard@...> escreveu:
 

32 MB.  The page size is in bytes.

If you did not have enough memory, the server will refuse to open the connection (needing the extra memory)  if I remember well.

 

De : brucedickinson@... [mailto:brucedickinson@...]
Envoyé : 15 janvier 2014 14:53
À : firebird-support@yahoogroups.com
Objet : [firebird-support] RE: Table update performance dropped significantly within few days.

 

 

Regarding the number of pages.

 

Correct me if I am wrong (http://www.firebirdsql.org/manual/gfix-buffers.html) but if Superserver is using 2048 pages and page size is 16384, than computer must have 32 GB RAM installed. What is happening when there is less RAM installed?