THANK YOU! It Will resolve my problem!
I will read this value and compare with a calculated value (number of connections, etc) and then set a new value. We are having performance problems when inserting a large amount of data in a huge table with a lot of indexes. We use a default 90 pages in a FB Classic 2.5.1 Windows server. Raising page caches to a higher value like 200 resolve our problems. I will read the server memory amount, read our maximum simultaneous connections and then calculate the 'best' and secure new page caches amount. Maybe I can except some trouble with this approach? De: [email protected] [mailto:[email protected]] Em nome de hvlad Enviada em: quinta-feira, 25 de abril de 2013 04:01 Para: [email protected] Assunto: [firebird-support] Re: How to read the "Memory buffers" size via SQL? --- In [email protected] <mailto:firebird-support%40yahoogroups.com> , "Fabiano Kureck" wrote: > > Hi! > > > > I must read the "Memory Buffers" parameter from the database using sql. > > I know that I can use gfix to change and gstat to read. > > > > I want to read it via a sql command. How do that? In recent Firebird versions you can query MON$DATABASE table. Regards, Vlad [Non-text portions of this message have been removed]
