hi,
i have a question about Ann W. Harrison's message
i am using firebird 1,5,2 with ibx

my connection string is that
user_name=SYSDBA
password=masterkey
lc_type=WIN1254
sweep_interval=20000
force_write=1

i am setting sweep interwal and forced writes when connecting to db.
is it to cause a problem.
is this wrong.

----- Original Message -----
From: "Ann W. Harrison" <aharrison@...>
To: <firebird-support@yahoogroups.com>
Sent: Saturday, March 25, 2006 12:19 AM
Subject: Re: [firebird-support] Sweep Interval and Garbage Collection


> Jason Dodson wrote:
>> I know the sweep interval is tunable, but I am unsure as to where. Also,
>> I got the impression some time ago that garbage
>> collection could be turned off... was I dreaming?
>>
>
> The sweep interval is stored in the database header page and updated
> with gfix, the services API, or a special dpb in an attach call. The
> new setting will take effect when ... probably when the last old
> connection exits, but I'm not entirely sure. New connections will see
> the new value, and there are locks to keep two sweeps from happening
> concurrently.
>
> Garbage collection can be disabled on a transaction-by-transaction
> basis. It's an option on the tpb of a start_transaction call. Don't do
> it without a very good reason, since garbage postponed is garbage
> fermented.
>
> Cheers,
>
>
> Ann
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
> __________ NOD32 1.1458 (20060324) Information __________
>
> This message was checked by NOD32 antivirus system.
> http://www.eset.com
>
>