Re: 7.30 -> 9.20 Anyone remember this?

UPDATE STATISTICS? From: dmoeller@geocities.com > >I have an existing 7.30.UC2 database where I run a large join query >(building a big fact table). I installed 9.20.UC2 into another >different INFORMIXDIR and dumped the schema from the 7.30 instance and >loaded up into the 9.20 instance for all the tables. > >I then setup connectivity between the instances and copied the data over >with select's. > >The problem is when I run the same large join query in the 9.20 >instance performance is terrible. 200 rows per second vs. 3000 rows a >second for the 7.30 instance. > >Awhile back I had a similar problem that was fixed by relinking some of >the files in /usr/lib. The problem with that is the 9.20 files have a 9 >in the name and the 7.30 instance files have a 7 in the name. So I'm >sure the 9.20 instance is not looking at the wrong files. > >Anyone remember this or encounter this before? /INFORMIXTMP come into >play anywhere? > >I'm quite sure it's not any of the ONCONFIG settings or indexes, etc. >Those are EXACTLY the same with the exception of course of the unique >parameters... > >Thanks, > >Dave > > >Sent via Deja.com http://www.deja.com/ >Before you buy. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com