9 vs 7
We recently upgraded from a 7.3 engine to 9.3 (also 7.2 4gl to 7.3). I've noticed isolated incidents of queries and programs with poorer performance since the upgrade. I expected of course at least marginal improvement. Both engines have basically the same set of tuning parameters so why the difference? Is there something in 9 that needs to be tuned different than 7? Bill Weaver, Development Manager IS, ext. 6525 Advantage Capital Corporation FSC Securities Corporation 2300 Windy Ridge Parkway Suite 1100 Atlanta, GA 30339 800-547-2382 770-916-6525 bweaver@fscorp.com <mailto:bweaver@fscorp.com> www.aigadvisorgroup.com<http://www.aigadvisorgroup.com/>; Securities and investment advisory services offered through Advantage Capital Corporation and FSC Securities Corporation, members NASD, SIPC and SEC-Registered Investment Advisers. AIG Advisor Group is the marketing designation for the wholly owned subsidiary broker-dealer members of AIG. This message and any attachments contain information from AIG Advisor Group, which may be confidential and/or privileged and is intended for use only by the addressee(s) named on this transmission. If you are not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are notified that any review, copying, distribution or use of this transmission is strictly prohibited. If you have received this transmission in error, please (i) notify the sender immediately by e-mail or by telephone and (ii) destroy all copies of this message.
It might help if you stated platform, number of CPU's etc. Thomas On Wed, 21 May 2003 13:21:41 -0400, "Weaver, Bill" <bweaver@fscorp.com> wrote: > >We recently upgraded from a 7.3 engine to 9.3 (also 7.2 4gl to 7.3). I've >noticed isolated incidents of queries and programs with poorer performance >since the upgrade. I expected of course at least marginal improvement. >Both engines have basically the same set of tuning parameters so why the >difference? Is there something in 9 that needs to be tuned different than >7? > >Bill Weaver, Development Manager >IS, ext. 6525 >Advantage Capital Corporation >FSC Securities Corporation >2300 Windy Ridge Parkway >Suite 1100 >Atlanta, GA 30339 >800-547-2382 >770-916-6525 >bweaver@fscorp.com <mailto:bweaver@fscorp.com> >www.aigadvisorgroup.com<http://www.aigadvisorgroup.com/>; >Securities and investment advisory services offered through Advantage >Capital Corporation and FSC Securities Corporation, members NASD, SIPC and >SEC-Registered Investment Advisers. AIG Advisor Group is the marketing >designation for the wholly owned subsidiary broker-dealer members of AIG. >This message and any attachments contain information from AIG Advisor Group, >which may be confidential and/or privileged and is intended for use only by >the addressee(s) named on this transmission. If you are not the intended >recipient, or the employee or agent responsible for delivering the message >to the intended recipient, you are notified that any review, copying, >distribution or use of this transmission is strictly prohibited. If you have >received this transmission in error, please (i) notify the sender >immediately by e-mail or by telephone and (ii) destroy all copies of this >message. >
IBM reckon that 9.31 has about the same performance as 7.31, prior to that 9.2x etc was slower than 7.31 "Weaver, Bill" wrote: > > We recently upgraded from a 7.3 engine to 9.3 (also 7.2 4gl to 7.3). I've > noticed isolated incidents of queries and programs with poorer performance > since the upgrade. I expected of course at least marginal improvement. > Both engines have basically the same set of tuning parameters so why the > difference? Is there something in 9 that needs to be tuned different than > 7? > > Bill Weaver, Development Manager > IS, ext. 6525 > Advantage Capital Corporation > FSC Securities Corporation > 2300 Windy Ridge Parkway > Suite 1100 > Atlanta, GA 30339 > 800-547-2382 > 770-916-6525 > bweaver@fscorp.com <mailto:bweaver@fscorp.com> > www.aigadvisorgroup.com<http://www.aigadvisorgroup.com/>; > Securities and investment advisory services offered through Advantage > Capital Corporation and FSC Securities Corporation, members NASD, SIPC and > SEC-Registered Investment Advisers. AIG Advisor Group is the marketing > designation for the wholly owned subsidiary broker-dealer members of AIG. > This message and any attachments contain information from AIG Advisor Group, > which may be confidential and/or privileged and is intended for use only by > the addressee(s) named on this transmission. If you are not the intended > recipient, or the employee or agent responsible for delivering the message > to the intended recipient, you are notified that any review, copying, > distribution or use of this transmission is strictly prohibited. If you have > received this transmission in error, please (i) notify the sender > immediately by e-mail or by telephone and (ii) destroy all copies of this > message. -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #