Re: HELP! Upgrade to V10

Posted in 2007

Bogdan BOTEZ — Tue, 2 Oct 2007 12:05:31 +0300 — source: Usenet: comp.databases.informix

On 10/2/07, Keith Simmons <smiley73@googlemail.com> wrote: > On 02/10/2007, Neil Truby <neil.truby@ardenta.com> wrote: > > "Keith Simmons" <smiley73@googlemail.com> wrote in message > > news:mailman.173.1191312549.26742.informix-list@iiug.org... > > > Was IDS7.31 FD6 on Solaris 5.8, upgraded to IDS 10 FC5. Followed the > > > migration guide and have updated stats. Performance stinks. The > > > database has many synonyms to a remote server, the link is LAN (100 > > > Mbs), the migration guide didn't mention synonyms specifically, any > > > view on whether it is worth dropping/recreating them?? > > > Any other thoughts on this migration? I need help quickly!! > > > > Update statistics?> > Hello Keith, If you already have a specific query with bad performance, how about schemas for the tables/views involved, execution plan, duration and data size? Regards, Bogdan BOTEZ.