sTesting wrote:
Hi,
I have a big problem, i wrote a very long function that is taking so
much time. inside this function i added few debugging steps to find
which section is taking most of the time, but all the created records
have the same time in them, the time where the fuction begins.
I tried to different methods:
INSERT INTO f_error (error_id, creation_date)
VALUES (nextval(''s_f_error_id''), now());
INSERT INTO f_error (error_id, creation_date)
VALUES (nextval(''s_f_error_id''), ''now'');
now() give you the time when the transaction started,
so what you see is the intended behavior, in your case you must use:
timeofday().
Regards
Gaetano Mendola
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
