I was doing an artificial performance test on Firebird by inserting into
a table that had a column
updatedts timestamp default localtimestamp
The insert did not touch this column (so the default is applied). To my
surprise, that was about 7 - 10 % slower than using CURRENT_TIMESTAMP:
updatedts timestamp default current_timestamp
Why is that?
I'd expect equivalent performance, or otherwise the reverse given the
current_timestamp timestamp with time zone value needs to be converted
to a timestamp without time zone.
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
