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;
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,
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
> 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.
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.
> 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] > >
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] >
> >
> 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
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