On 2019/03/27 17:10, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
On 27-3-2019 13:01, 'Stellarancia.com' ni...@stellarancia.com
[firebird-support] wrote:
> Good morning,
> My clients use an application written with Delphi that use a Firebird
> Database 2.5 (business
Hi
I understand UPDATE ... RETURNING only works with single select.
I have the following procedure
UPDATE STAFF_EVENTS SET DT_END = current_timestamp(0),
LEN = dateadd(minute, datediff(minute, dt, current_timestamp(0)),
cast('30.12.1899 00:00' as Timestamp))
WHERE
Hi
My software using FB 2.54 (SuperServer) and Firedac (Delphi 10.1) connected
fine on a workstation to the "SERVER". All the required connection files are
in the software folder and I did not do the FB Client installation on the
workstation.
Another company then did a custom Firebird
I have 1 out of 50+ Firebird installations that slows done dramatically after a
time (+- 24 hours) Queries that normally takes less than 0.01 secs takes 5-8
secs). Specs of problem Server: Firebird 2.5.2 SS, 2GB, Win XP SP2 with just 1
workstation connected.
I did a backup/restore, check
Thanks for the reply Carlos. Very little, mostly the software adds and reads
records, very few are updated. No were near 2 for the swipe to activate in
the time period. The big issue is that the speed never returns to normal.
Regards
Cornie