Re: Query Speeds 7.20 -> 7.30

I'm currently testing 7.30.UC7 with tools version 7.20.UD8, Hp-Ux 10.20 , I've run queries as described, both came back in about the same time. The queries were simple select count(*) from mytable where date_column > test_date. -- --------------------------------------- Tony Flaherty aef@mfs.misys.co.uk Analyst Programmer Misys Financial Systems All statements and opinions are my own, Misys don't pay me enough to have opinions on their behalf . jasonb@brandes.com wrote in message <7o9s3m$lul$1@nnrp1.deja.com>... >Question, we have recently installed Informix 7.3 on NT platform. When >running queries we have noticed a substantial decrease in speed when >queries are run using a "mmddyy" format rather that the "today" function >(i.e. where datefield <= 080499 ) > >The query with the today returns the results in seconds, where the >query with "080499" takes 8 - 10 minutes. > >On 7.2 both ran equally fast. I've compared the onconfig files and all >query optimizer values are the same... > >As we are rolling out 7.3 soon, this is a critical problem as we have >applications and scripts which have date values in them. > >Any help would be appreciated. > > > >Thanks.. > > >Jason Baker >jasonb@brandes.com > > >Sent via Deja.com http://www.deja.com/ >Share what you know. Learn what you don't.