BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: No events within the next 45 days.

[IDT 4.x] ANSI 92 Performance issues


 
Search this topic... | Search Semantic Layer / Universe Designer... | Search Box
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Author Message
jacquib
Senior Member
Senior Member



Joined: 17 Aug 2008

Posts: 68



PostPosted: Thu Sep 26, 2019 8:50 pm 
Post subject: ANSI 92 Performance issues

Hi,

We are using IDT 4.1 and Oracle 11. We've just converted the universe over to ANSI and during our testing notice on average 30% degradation in performance per report.

I'm wondering if anyone else may have encountered the same and if so, what advice you may have to share.

Thanks in advance

Jacqui
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11422
Location: Manchester, UK


flag
PostPosted: Fri Oct 25, 2019 11:24 am 
Post subject: Re: ANSI 92 Performance issues

Other than an ansi conversion, have you done anything else?

Can you put the queries into, say, TOAD and view the new explain plans to see if the query is behaving differently in the new and old worlds?

_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
Back to top
jacquib
Senior Member
Senior Member



Joined: 17 Aug 2008

Posts: 68



PostPosted: Thu Oct 31, 2019 10:39 pm 
Post subject: Re: ANSI 92 Performance issues

Hi Mark,

From a purely BO perspective, the ANSI conversion was the only difference. I'm not aware of any changes in the back end that may have occurred. The ANSI changes were re-tested with only marginal degradation subsequently so we have proceeded.

Thanks for the response.

Jacqui
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0268 seconds using 17 queries. (SQL 0.0019 Parse 0.0009 Other 0.0241)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo