Patrick,
> recently we had some strange performance issues with our Firebird DB server.
>
> On high load, our server started to slow down. Select and update SQL
> query times did go up by more than 500% on average,
>
> but reaching unreasonable high execution times at worst case. (several
>
hi,
recently we had some strange performance issues with our Firebird DB server.
On high load, our server started to slow down. Select and update SQL query
times did go up by more than 500% on average,
but reaching unreasonable high execution times at worst case. (several minutes
instead of <
>>No, the index entry does not include transaction information. So yes, if
>>you have a database that includes something
>>m to m relationship, the junctions records have to be read to validate
>>them for the current transaction. M to m
>>relationships are typically something like: students,
I have an cluster of older database formats (32bit firebird 1.5) and I wish to
see about migrating them to a newer firebird 2.5 64 bit format.
We replicate using older custom C code on telco servers, so redesigning the
replication code and getting it certified for use is a non-starter.
So,
Hi,
Which is the better approach to make a case insensitive SIMILAR TO query ?
Example:
CREATE TABLE LOOKUP_ARTICLE
(
ID INTEGER NOT NULL,
HEADLINE VARCHAR(100) NOT NULL,
PUB_DATE TIMESTAMP NOT NULL,
AUTHOR_ID INTEGER,
CONSTRAINT INTEG_354 PRIMARY KEY (ID)
);
INSERT INTO
> Dear all,
> If blocking SYSDBA from connecting the database is the goal, than ones can
> create a role with the name SYSDBA.Is there any minus about this?
AFAIR, this needs to be done with a direct system table insertion in RDB$ROLES
with 2.5 and earlier. I don't know if this has changed in
Dear all,
If blocking SYSDBA from connecting the database is the goal, than ones can
create a role with the name SYSDBA.Is there any minus about this?
Regards,Tjioe
Hi,
> Dear all,
> Though I don't have the same question as Roland, information below by Virna
> Constantin (costel...@yahoo.com) is very useful.Thanks every one.
> Regards,Tjioe
>
> Suggestion
> event studies "on connect"
> 1. an application with minimum rights connects to the database
> 1 '. in