Re: [firebird-support] Re: Connecting to Firebird database from two or more pc with same username

2016-04-18 Thread Virna Constantin costel...@yahoo.com [firebird-support]
I hope I did do not a fixation by "on connect"  :D SET TERM ^ ;ALTER TRIGGER USER_ON ACTIVEON CONNECT POSITION 0AS   declare variable m_gaz varchar(25);BEGIN     select mon$remote_address from MON$ATTACHMENTS         where mon$attachment_id=current_connection        into :m_gaz;   

[firebird-support] Performance issues moving to new server with later Firebird version

2016-04-18 Thread mailgro...@murdochfl.com [firebird-support]
We have a 127GB Firebird database that was running on Windows Server 2008 x64 with 16GB of RAM and Firebird SuperClassic v2.5.2.26539. The database has a page size of 8192 and buffers of 6144, and ODS version 11.2. Due to time constraints I could not do a backup+restore on the new server,

Re: [firebird-support] Database performance slowdown

2016-04-18 Thread Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
Neil, > We are investigating an issue with one of our systems where it gradually > slows down during the course of a day. > > We have our epos system that we write ourselves using Delphi XE2 and > the IBX components. How does your transaction model/layer look like in your client application

[firebird-support] RE: Database performance slowdown

2016-04-18 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
> We are investigating an issue with one of our systems where it gradually > slows down during the course of a day. > > We have our  epos system that we write ourselves using Delphi XE2 and the > IBX components. > We have a group of tables that are updated during the end of sale save > process.

[firebird-support] Database performance slowdown

2016-04-18 Thread 'Neil Pickles' neil.pick...@csy.co.uk [firebird-support]
We are investigating an issue with one of our systems where it gradually slows down during the course of a day. We have our epos system that we write ourselves using Delphi XE2 and the IBX components. We have a group of tables that are updated during the end of sale save process.

Re: [firebird-support] Re: Connecting to Firebird database from two or more pc with same username

2016-04-18 Thread 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
> On Mon, Apr 18, 2016 at 10:03 AM, 'Thomas Steinmaurer' t...@iblogmanager.com > [firebird-support] wrote: > >> > On Thu, 14 Apr 2016 12:28:41 +0200 (CEST), 'Thomas Steinmaurer' >> > t...@iblogmanager.com [firebird-support] > >

Re: [firebird-support] Re: Connecting to Firebird database from two or more pc with same username

2016-04-18 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Mon, Apr 18, 2016 at 10:03 AM, 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] wrote: > > On Thu, 14 Apr 2016 12:28:41 +0200 (CEST), 'Thomas Steinmaurer' > > t...@iblogmanager.com [firebird-support] > > >

Re: [firebird-support] Re: Connecting to Firebird database from two or more pc with same username

2016-04-18 Thread 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
> On Thu, 14 Apr 2016 12:28:41 +0200 (CEST), 'Thomas Steinmaurer' > t...@iblogmanager.com [firebird-support] > wrote: >> >> >> Yep. If one want to have some sort of client login/user available on >> the server-side, which might be totally different to the

[firebird-support] Re: Connecting to Firebird database from two or more pc with same username

2016-04-18 Thread Virgo Pärna virgo.pa...@mail.ee [firebird-support]
On Thu, 14 Apr 2016 12:28:41 +0200 (CEST), 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] wrote: > > > Yep. If one want to have some sort of client login/user available on > the server-side, which might be totally different to the Firebird > user