Dne 31. 1. 2017 v 10:14 Köditz, Martin martin.koed...@it-syn.de
[firebird-support]:
> does anybody know an elegant statement to create random dates? It
> would be perfect to define a range.
select DATEADD(FLOOR(365*RAND()) DAY TO DATE'2016-1-1') from rdb$database;
RAND() returns DOUBLE
> SYSDBA users can see other connected users using monitoring tables
> but is it possible to implement such feature for non-SYSDBA users? Are
> there event/triggers that act uppon connecting and disconnecting and
> which can insert usual database records. Triggers no MON$ tables are
> not
I have a huge table to import - tens millions of rows.
From my experience, it is not good practice to commit job after importing
everything, because import of rows can become slower and
slower.
So, i decided to make commit after every 50.000 rows. So far so good.
There is no reason to not
We're in the process of changing an application that accesses a Firebird
database file from a regular application to a windows
service. For legacy reasons this uses the Firebird embedded DLL (fbclient)
for version 1.5.6. The code that attempts to connect to
this file always succeeds as a