[firebird-support] Re: Strange behavior on very large table

2019-02-22 Thread my...@techsol.org [firebird-support]
Hi Karol, I'm going to run some tests on the database this weekend as I think I know how to trigger this behavior. Once I get it to do that, I'll get the results and post them. Thanks Myles

[firebird-support] Re: Strange behavior on very large table

2019-02-22 Thread my...@techsol.org [firebird-support]
Hi Lester, I have definitely asked similar questions to the client. But they have started to use this historical database for their own reporting, etc. and that isn't its original purpose. Having said that, there is not an easy way to identify changes, but I may talk to them further about

[firebird-support] Re: Strange behavior on very large table

2019-02-22 Thread my...@techsol.org [firebird-support]
Thanks Mark. The nightly load process is triggered by the availability of the source CSV file that is provided by a 3rd party, and we don't have that much control over when this is produced. It is one of those things that the second we get to access it, then the database has to begin the kill

Re: [firebird-support] Re: Strange behavior on very large table

2019-02-22 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 22-2-2019 05:33, my...@techsol.org [firebird-support] wrote: > Thanks Helen.  Just a few clarifications, that might help whittle this > down a bit... > > >Given that this table is "temporary" storage, one supposes that you > are deleting rows from it regularly. Do you happen to be deleting >

Re: [firebird-support] Re: Strange behavior on very large table

2019-02-22 Thread Lester Caine les...@lsces.co.uk [firebird-support]
On 22/02/2019 04:33, my...@techsol.org [firebird-support] wrote: > >Given that this table is "temporary" storage, one supposes that you > are deleting rows from it regularly. Do you happen to be deleting > 900,000 rows each day before you load up the latest batch of 900,000? How much information