Query taking long to execute
Paul Gathogo migrated from IDS 7.3 to IDS 10 on SUSE Linux 10 and found queries very slow. allen.philip asked if statistics were updated. Art Kagel said to drop all the 7.31 data distributions and rebuild them with version 10. Mark Jamison agreed and asked for an onconfig diff, OPTCOMPIND and OPTGOAL values, and sample slow queries. No outcome reported.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi all, Guys i've just finished migrating my DB from IDS 7.3 to IDS 10 on suse linux 10, my problem is the queries seems to take like forever to execute, which is not the case with my old IDS, what am i missing? Paul
I was wondering , have you updated your statistics? -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of PAUL GATHOGO Sent: Wednesday, April 11, 2007 12:04 PM To: ids@iiug.org Subject: Query taking long to execute [8816] Hi all, Guys i've just finished migrating my DB from IDS 7.3 to IDS 10 on suse linux 10, my problem is the queries seems to take like forever to execute, which is not the case with my old IDS, what am i missing? Paul ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com
You need to drop all of hte 7.31 data distributions and rebuild them using 10. ----- Original Message ----- From: Paul Gathogo <ids@iiug.org> At: 4/11 2:34:11 Hi all, Guys i've just finished migrating my DB from IDS 7.3 to IDS 10 on suse linux 10, my problem is the queries seems to take like forever to execute, which is not the case with my old IDS, what am i missing? Paul ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Hi Paul,
As several people have mentioned. Rebuilding your distributions is a must.
Any chance you can send a diff of the onconfig between version 7 and 10?
And the values for the following, if they are the same:
OPTCOMPINDOPTGOAL
Oh and can you give some exacmple queries that are slower, and whether or not
they use views.
Thanks Much,
Mark
----- Original Message ----
From: PAUL GATHOGO <pgathogo@gmail.com>
To: ids@iiug.org
Sent: Wednesday, April 11, 2007 1:33:42 AM
Subject: Query taking long to execute [8816]
Hi all,
Guys i've just finished migrating my DB from IDS 7.3 to IDS 10 on suse linux
10, my problem is the queries seems to take like forever to execute, which is
not the case with my old IDS, what am i missing?
Paul
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.