Re: SE7.1 - SLOW!

On Wed, 13 Dec 1995, Sally Woolrich wrote: > In article <4akujf$bma@dub-news-svc-1.compuserve.com> > 100662.1447@compuserve.com "Guenther Koegebehn" writes: > > > We've switched to an SE7.1 and it's a lot(!!!) slower than the 4.xx / > > 5.xx with p-code and isql. (RDS/SQL 6.01) > > We found that switching major engine versions could always make certain > statements run slower as the optimizer changes, and we had to revisit > some areas of the product to sort the problems out. Could this > be happening for you too? <g> > Sally et al. When we changed from SE 4+ to 5+, our queries took a nose dive. Discovered that our previous where fld1 = 9999 (an alpha filled with numerics) was slow; putting quotes around the value was all she needed. These are the little niceties <g> make life interesting. Ho, ho, ho. Yours, Nick ********************************* Nick Nobbe, Library of Congress NLS/BPH mail: nnob@loc.gov *********************************