[firebird-support] Re: Bloated security2.fdb

2017-03-06 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
06.03.2017 21:48, 'Neil Pickles' wrote: > One thing I don’t understand is why there would be over 744 million txns > on this file? Is a new txn started each time a connection to the > database is made? Of course, the server needs to validate your login/password against the security database. >

[firebird-support] Bloated security2.fdb

2017-03-06 Thread 'Neil Pickles' neil.pick...@csy.co.uk [firebird-support]
Hopefully someone knows the answer to this, it has puzzled me for some time now . . . I'm running Firebird v2.1 on Windows for a large customer and I have again come across a very bloated security2.fdb file. It seems to make no difference whether it is Classic or Super and Firebird v2.5 seems

RE: [firebird-support] QUERY QUESTION

2017-03-06 Thread 'Stef' s...@autotech.co.za [firebird-support]
Brilliant thank you Set that does the trick Stef van der Merwe From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: 06 March 2017 09:05 AM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] QUERY QUESTION WITH TMP(ItemNr,