[firebird-support] Re: wcdata.fdb file opened many times, hogging space !

2013-11-22 Thread Philippe Makowski
Le 21/11/2013 00:58, Jerome Bossert a écrit : > if i do a kill pid, it release the space, but i want to understand the issue > and fix it in a proper way. don't delete files when they are in use, that's all

[firebird-support] Firebird 1.5 Order by Query

2013-11-22 Thread vendee928
Hi, I have a simple query: SELECT first 1 ITEM_DATE FROM HISTORY WHERE ITEM_ID = 'ITEM_ID_123456' and ITEM_TYPE = 'TYPE1' AND ITEM_STATUS > 200 and ITEM_STATUS <> 310 ORDER BY ITEM_DATE ASC Which runs in about 1.5 seconds. If I remove the Order by it's less than 100ms. There are o

[firebird-support] RE: Firebird 1.5 Order by Query

2013-11-22 Thread vendee928
The table is quite large, btw. (Around 24 million records)

RE: [firebird-support] Firebird 1.5 Order by Query

2013-11-22 Thread Svein Erling Tysvær
>I have a simple query: > >SELECT first 1 ITEM_DATE FROM HISTORY >WHERE ITEM_ID = 'ITEM_ID_123456' >and ITEM_TYPE = 'TYPE1' >AND ITEM_STATUS > 200 and ITEM_STATUS <> 310 >ORDER BY ITEM_DATE ASC > >Which runs in about 1.5 seconds. If I remove the Order by it's less than >100ms. There are only three

RE: RE: [firebird-support] Firebird 1.5 Order by Query

2013-11-22 Thread vendee928
Yes, thanks, that's made the performance between the two queries comparable again. ---In firebird-support@yahoogroups.com, wrote: >I have a simple query: > >SELECT first 1 ITEM_DATE FROM HISTORY >WHERE ITEM_ID = 'ITEM_ID_123456' >and ITEM_TYPE = 'TYPE1' >AND ITEM_STATUS > 200 and

[firebird-support] Cannot restore primary key constraint after removing

2013-11-22 Thread scottb
Greetings all, I am removing a primary key constraint in order to speed up an import of many records. After the import, I commit all changes, and then restore the primary key to my table with this: ALTER TABLE CHARGE ADD CONSTRAINT PK_CHARGE PRIMARY KEY (CHARGE_TABLE_ID) The statem

[firebird-support] Cannot restore primary key after removing it

2013-11-22 Thread scottb
Hi, I am experiencing a problem when I try to restore a primary key constraint after removing it. I am removing it to speed up the import I am doing. (perhaps this does not speed things up so much ?) Anyways here is what it looks like in general: ALTER TABLE CHARGE DROP CONSTRAINT PK_CHAR

RE: Re: [firebird-support] wcdata.fdb file opened many times, hogging space !

2013-11-22 Thread jbossert
No i'm not deleting any file. -we use the gfix script to stop the db every night, and make a backup. this is not releasing the hogged space (fb_inet process still running) ! we use "gfix -user sysdba -password -shut full -force 0 wcdata.fdb", then the DB is dow, we we try to connect to

Re: [firebird-support] Cannot restore primary key constraint after removing

2013-11-22 Thread Carlos Tré
On 22/11/2013 15:24, sco...@workingsystems.com wrote: attempt to store duplicate value (visible to active transactions) in unique index "PK_CHARGE" I have checked count on the primary key field, and there appears to be only one instance for each "CHARGE_TABLE_ID". I have backed up and restor

[firebird-support] what should i think of when creating a shared server with firebird?

2013-11-22 Thread g80rock
it's time we start creating servers for firebird. i thinking of shared servers, like they do on mysql on almost all shared server around the world. i am thinking of selling shared server accounts with firebird. what do i have to think of and what do i need to be successful? simple questio