[firebird-support] Re: How to read the Memory buffers size via SQL?

2013-04-25 Thread hvlad
--- In firebird-support@yahoogroups.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

RES: [firebird-support] Re: How to read the Memory buffers size via SQL?

2013-04-25 Thread Fabiano Kureck
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

RE: [firebird-support] Re: How to read the Memory buffers size via SQL?

2013-04-25 Thread Leyne, Sean
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. I forgot about MON$Database table. I

[firebird-support] Re: Firebird 2.5 performance slower then 2.1 especially SuperClassic...

2013-04-25 Thread ssilouky
We have experienced similar results when trying to upgrade to 2.5.2 SuperClassic on a Windows 2008 R2 Server. Are there any tools available to track the performance of firebird applications? --- In firebird-support@yahoogroups.com, randallsell randallsell@... wrote: Hello all, I recently

[firebird-support] Refreshing MON@ATTACHMENTS: Limiting the number of users

2013-04-25 Thread homerjones1941
Limiting the number of users has been discussed before, but I still have a couple of unanswered questions. We have a multi-user Delphi application with a Firebird 2.14 database. User access is controlled by the app, which connects using a single log in (not SYSDBA). The application limits the

[firebird-support] Temporarily stop and disable garbage collection

2013-04-25 Thread Robert martin
Hi We have a need to ensure garbage collection is not running in a given database. Ideally we would stop / cancel any garbage collection in progress, do our stuff, then turn garbage collection back on. Is this possible? Thanks Rob

Re: [firebird-support] Temporarily stop and disable garbage collection

2013-04-25 Thread eMeL
Is this possible? http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gfix-cmdline.html Sure. see parameter: -housekeeping set sweep interval n usage: gfix [options] database plausible options are: -activate activate shadow file for database

Re: [firebird-support] Temporarily stop and disable garbage collection

2013-04-25 Thread Robert martin
Is this possible? http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gfix-cmdline.html Sure. see parameter: -housekeeping set sweep interval n Hi I was probably not specific enough in my problem description :) I know that I can disable garbage collection

Re: [firebird-support] Temporarily stop and disable garbage collection

2013-04-25 Thread Alexandre Benson Smith
Em 25/4/2013 21:58, Robert martin escreveu: Is this possible? http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gfix-cmdline.html Sure. see parameter: -housekeeping set sweep interval n Hi I was probably not specific enough in my problem description :) I

Re: [firebird-support] Temporarily stop and disable garbage collection

2013-04-25 Thread Ann Harrison
Here's the discussion: I know that I can disable garbage collection via the cmd line. What I am looking for is the ability to... 1. Cancel any existing garbage collection 2. Disable garbage collection 3. Do my stuff 4. Re enable garbage collection. That's an odd request. It