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
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
The table is quite large, btw. (Around 24 million records)
>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
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
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
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
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
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
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
10 matches
Mail list logo