|Subject||Re: [firebird-support] RE: Insert into Large Table is slowly!|
|Author||Alexandre Benson Smith|
Em 5/9/2013 13:18, jym013@... escreveu:
Thanks, I will try use GLOBAL TEMPORARY and INACTIVE index.
The insert time will be faster without the index, but you will spend a lot of time when you reactivate it... And any query that will run during the insert time will not use the indice, so, it will be very slow to do a full table scan in a multi million record table....
Take into account that you will reactivate the index 24 times a day....