I resend my email - it do not reaach the yahoo group :-(
Hi,
you can try modify your logic by adding IMPORT_ID to that table
and then you can import data without need to delete in the same time.
Then you can delete data in some portions during a day.
and successively run
SELECT COUNT(*)
An update and a huge thank you to everyone for your input and help on this. I
spent most of yesterday writing Linux bash scripts and closing off ports on the
database server so I could run this from a remote SSH request from a web
server. I wrote a pretty extensive script library that will
Hi Mark,
> On 30-5-2019 16:14, Thomas Steinmaurer t...@iblogmanager.com
> [firebird-support] wrote:
>>> Also one further question Do later versions of Firebird (ie. 3 or
>>> 4) have any performance increase for cooperative garbage collection at
>>> all? Would I expect to see any performance
MRmlnfs> Truncate table (CORE-2479) isn't implemented yet, so it is unsure this
MRmlnfs> will land in Firebird 4.
MRmlnfs> Mark
Btw, truncate was predicted for Firebird 3, but something seems to be
delaying its implementation :-(
I hope it will be available for FB 4, and even better if it can
On 30-5-2019 16:14, Thomas Steinmaurer t...@iblogmanager.com
[firebird-support] wrote:
>> Also one further question Do later versions of Firebird (ie. 3 or
>> 4) have any performance increase for cooperative garbage collection at
>> all? Would I expect to see any performance improvement by
> Also one further question Do later versions of Firebird (ie. 3 or
> 4) have any performance increase for cooperative garbage collection at
> all? Would I expect to see any performance improvement by any newer
> version, or different server implementation here?
Likely TRUNCATE TABLE ...
On 30-5-2019 01:26, my...@techsol.org [firebird-support] wrote:
> >To me this sounds like the cooperative garbage collection kicks in when
> you select from the table. You may want to consider dropping the table
> entirely and recreating it. Alternatively, switch to SuperServer and set
> its
> Also one further question Do later versions of Firebird (ie. 3
> or 4) have any performance increase for cooperative garbage
> collection at all?
No. GC requires reading the version chain of all records in the
contexts of their transactions. It takes as long as it takes.
> Would I
Also one further question Do later versions of Firebird (ie. 3 or 4) have
any performance increase for cooperative garbage collection at all? Would I
expect to see any performance improvement by any newer version, or different
server implementation here?
Thanks
Myles
>That is your solution - but *do not delete those records*.
Thank you for the detailed reply, Helen. I can definitely execute a script to
drop all dependencies and then drop the table, and then rebuild them back in
via a CLI Linux script. I thought that was pretty extreme, but if this is the
>To me this sounds like the cooperative garbage collection kicks in when
you select from the table. You may want to consider dropping the table
entirely and recreating it. Alternatively, switch to SuperServer and set
its garbage collection policy to background (I believe this was
introduced in
11 matches
Mail list logo