Ticket #137 (new defect)

Opened 2 months ago

Last modified 2 months ago

Serious performance regression in date comparison

Reported by: schka01 Assigned to: admin
Priority: major Milestone: summer08
Component: server Version: main
Keywords: date performance Cc:

Description

date comparison slowdown with timezone changes (main 491522/491531). 10% overall CPU slowdown in TPC-H runs, implies many-times slowdown in date comparison itself.

Slowdown is with ingresdate/ingresdate comparison, pure date values, no time parts. ansidate is equally slow. PC snapshots show TMtz_search, adu_6to_dtntrnl, ad0_tz_offset showing a lot.

Change History

05/08/08 06:21:56 changed by anonymous

This may relate to a problem/bug I reported few days ago. In the problem ingresdate without timezone gets casted to ingresdate with timezone in outer join. You may want to check issue 127855. :) -- Pauli Borodulin

05/18/08 17:28:12 changed by rosan01

  • version set to main.
  • milestone set to summer08.