Chr*s, I'm the wrong person to ask about the OS version, but I doubt it. And yes, same computer(s), same infrastructure, just different versions of R:Base and a newly-converted database. Something I should do, though, before I shoot my mouth off about my theories, is check the sys_indexes.sys_index_size, sys_dup_factor and sys_adj_factor of the indexes that are involved in the tables that are referenced in the views that have speed differences between versions, and see if the conversion reload process computed any of the optimization statistics differently from one database to the other.
No time to do that today, though, my work week is short. Razzak and R:BASE eXtreme 9.0 are coming to town this afternoon! Bill On Thu, May 7, 2009 at 9:53 AM, Chris Robbins <[email protected]> wrote: > “After conversions to 8.0, I had a few instances of reports that were > slower than they had been in 7.6.” > > I would imagine that this was done on the same machine with the same > hardware….?..... > > “I have a theory -- based on little knowledge -- that there are some > formulas in the "query optimizer" that do some hard-coded math with > assumptions about 32-bit pointers in indexes. In 8.0, the pointers are > 64-bits.” > > If that is the case: would utilizing a 64 bit OS make any difference? > > >
