If record with BLOBs is inserted into temporary table, create copy of BLOB
content in temporary space
-----------------------------------------------------------------------------------------------------
Key: CORE-4157
URL: http://tracker.firebirdsql.org/browse/CORE-4157
Project: Firebird Core
Issue Type: Improvement
Components: Engine
Reporter: Dimitry Sibiryakov
Consider this code in after insert or update trigger on permanent table:
BEGIN
INSERT INTO temp_table (blob_field) VALUES (new.blob_filed);
END
Currently copy of BLOB's content is created in permanent storage, decreasing
effectiveness of the operation and blowing DB file. Besides, on commit or
disconnect this new copy of the BLOB is cleaned out, slowing down the process
even more.
With BLOB content in the same temp space as the temp table, there is no need to
run ordinary garbage collection process with records analysing and BLOBs
erasing, it is enough to drop whole temp file.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Get your SQL database under version control now!
Version control is standard for application code, but databases havent
caught up. So what steps can you take to put your SQL databases under
version control? Why should you start doing it? Read more to find out.
http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
