org.mozilla.javascript.NativeDate REALLY slow

jsherriff

I thought I'd resolved this, but I guess not. If I add a filter to a cube that references a date-time column - given enough rows - in my case ~6000, it takes _minutes_ to complete the running of my report. Removing the filter or filtering by a field of any other type takes seconds. Doesn't seem to be anything to do with the complexity of the filter, only thing that seems to matter is whether the column is a date-time type. Debugging I see that the scripting engine sees it as a NativeDate type. Looking at the source for NativeDate, looks like NativeDate is doing a lot - I just need the epoch time from it, what getTime() returns - in theory what the original java.sql.Date or Timestamp value was, is there a shortcut? I see a lot of private fields and nothing I can get at.

Basically it's too slow to use like this - anyone have any ideas for work arounds? The only thing I can think of requires me to convert all date/timestamps in my sql to longs and re-create them as dates as necessary. Seems like an awful lot of work.