Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > Performance & Tuning

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 7th October 2005, 11:49
ayoobi's Avatar
ayoobi ayoobi is offline
Member
 
Join Date: Jun 2002
Location: Japan
Posts: 73
ayoobi is on a distinguished road
Baan: Vb Vc - DB: Oracle - OS: NT , UNIX
Query is Slow at times

Hi ,

I am facing a strange problem. I have query in a BOI DLL which normally takes 3-4 seconds to execute. But sometimes it takes 200-350 seconds to execute the same query. First BOI Call in the morning and after lunch. Sometimes in between too this query takes time.
any clues as to why query slows down drastically at times?

Thanks in Advance
Ayoobi
Reply With Quote
  #2  
Old 7th October 2005, 16:07
Dikkie Dik's Avatar
Dikkie Dik Dikkie Dik is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 585
Dikkie Dik is on a distinguished road
Baan: Triton 3.0 and higher - DB: All - OS: All
When having Oracle as a database it looks like you fase a parsing problem: The first time a query is executed, a plan has to be build how to access the data. Som BOI's build queries on 20+ tables that can confuse the optimizer and thus take a lot of time. Depending on the version of your database I can give you some hints.

Another reason can be that before you do your query someone else ruined the Oracle cache by reading something very huge and thus removing your cached data from the database. This can happen in the early morning when a fresh start of the database occurs, but when someone else reads half of the database, it can ruin your cached data.

Hope this helps,
Dick
__________________
BTW: this post has been made on my personal view. My employer might not share my point of view.
Reply With Quote
  #3  
Old 8th October 2005, 07:55
ayoobi's Avatar
ayoobi ayoobi is offline
Member
 
Join Date: Jun 2002
Location: Japan
Posts: 73
ayoobi is on a distinguished road
Baan: Vb Vc - DB: Oracle - OS: NT , UNIX
We are on Oracle 9i

Hi Dik,

Thanks for your explanation ! I think now i understand this strange behaviour.

Infact, this query was quite inefficient. So hopefully improving this query should solve this problem.

Thanks
Ayoobi
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't query the ttadv380 table. walter01 Tools Development 23 17th September 2006 01:18
Desktop Query eshirley Tools Administration & Installation 0 10th September 2002 02:41


All times are GMT +2. The time now is 23:15.


©2001-2017 - Baanboard.com - Baanforums.com