-support] Question about few Firebird details
Hi Karol,
44. This option turn off individual savepoints. Our tests proof that gives
slight increase in case of massive inserts or updates. Use it with caution,
since the rollback will be forced (through TIP), so if you insert less than 50k
records
Hi Karol,
44. This option turn off individual savepoints. Our tests proof that
gives slight increase in case of massive inserts or updates. Use it
with caution, since the rollback will be forced (through TIP), so if you
insert less than 50k records, there could be difference with and without
23.05.2016 21:05, liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
wrote:
> 44. Use NO_AUTO_UNDO - what happend when i do rollback?
You will get hard rollback, frozen OAT counter and unavoidable run of sweep.
--
WBR, SD.
Hi,
https://ib-aid.com/en/articles/45-ways-to-speed-up-firebird-database/
i have few questions:
44. Use NO_AUTO_UNDO - what happend when i do rollback? I do not understand
what really do this option..
30. Use derived tables to optimize SELECT with ORDER BY/GROUP BY -
SELECT T.FIELD_KEY,