Re: 7.x to 9.x Performance issue in the extreme

Tom Lowrie wrote: > Greetings, > > The problem: I run an identical program on Server A and Server B. On > Server A the program runs in 12 seconds. On Server B it takes 1.5 > hours. > > Server A: IBM RS/6000 H80, AIX 4.3.3.0.11, IBM IDS 7.31.UC7 > > Server B: IBM RS/6000 S80, AIX 4.3.3.0.9, IBM IDS 9.30.UC2 > > The only difference in the hardware on these 2 servers is Server A has > 6 Gigabytes of RAM while Server B has 4. The SSA Disk subsystems are > identical. > > Both servers use the 4J's "front end", installed and compiled on each > server in accordance with the 4J's installation guidelines. > > Both servers are dedicated to running the IDS and the Application > software only. The application software is identical on both servers. > The application software resides on the same server as the IDS. Both > servers are pretty much running at the same load level ' not stressed > at all. Both appear to have plenty of available memory and plenty of > available CPU time. There is no I/O issue on either server. In short, > plenty of hardware for the task at hand. > > The data in the DB is identical on both servers. The program that > generates the update statistics SQL is identical on both servers. The > indexes are identical on both servers. The total size of the database > after import is less than 2.5 Gig. The tables being accessed for this > report are all under 120 Meg. > > The onconfig files are identical on both servers except for: > > Variable: Server A: Sever B: > SHMVIRTSIZE 786432 524288 > SHMADD 262144 393216 > STACKSIZE 32 64> > The program is a YTD Budget Report that takes a few parameters then > goes out to the database to collect the data and generate the report. > Nothing fancy. Nothing spectacular. Just your normal, everyday > accounting type report. > > The speed on system B in all other areas is excellent. Normal "Finds" > against the largest tables, moving between screens, > adding/deleting/changing field data, etc all runs fine. > > Given this info, where do I look for the problem? UPDATE STATISTICS? -- Ciao, The Obnoxious One "Ogni uomo mi guarda come se fossi una testa di cazzo"