Subject RE: [firebird-support] Re: Performance when deleting a lot of records, again
Author Gili Buzaglo
I've perfomed gstat -h on every write to the database, to see when next transaction number becomes
a lot larger the oldest snapshot number.
I've noticed that when ever it occured the following select was performed for the first time:

select DISTINCT v.vol_id,sd.dev_id,pa.cc_id,ba.branch_id,sd.allocation,s.allocation,ba.allocation,pa.allocation,da.allocation,s.stt_id,da.disk_id,cm.client_id from stt_allocation s LEFT JOIN volume v on s.stt_id = v.stt_id and v.vol_id = ?
Left JOIN client_map cm on cm.vol_id = v.vol_id
Left join stt_comp sc on s.stt_id = sc.stt_id
Left join Storage_device sd on sc.dev_id = sd.dev_id
LEFT JOIN device_owner do1 on sd.dev_id = do1.dev_id Left join branch_visibility bv on do1.branch_id = bv.branch_id and bv.is_owner=1
Left join pool_allocation pa on pa.cc_id = bv.cc_id
Left join branch_allocation ba on ba.branch_id = do1.branch_id
Left join DISK_ARRAY_STORAGE das on das.dev_id = do1.dev_id
Left join disk_allocation da on da.disk_id = das.disk_array_id
WHERE v.vol_id is not null;

All *_allocation are views , the rest are tables.

Can you see any problem with this query ?

-----Original Message-----
From: Ann W. Harrison [mailto:aharrison@...]
Sent: Thursday, April 07, 2005 7:52 PM
Subject: Re: [firebird-support] Re: Performance when deleting a lot of records, again

Gili Buzaglo wrote:
> What is a culprit ?
> Anywhay, even if I close the ibconsole, there is still a gap!

The culprit is the guilty person. IBConsole starts a snapshot
transaction when you use it to query the database. That transaction
stays open until explicitly closed.

Try closing all connections to the database, then run gstat -h and send
us the results.




Yahoo! Groups Links

* To visit your group on the web, go to:

* To unsubscribe from this group, send an email to: <>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <> .

[Non-text portions of this message have been removed]