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
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 7th March 2004, 11:57
rochus rochus is offline
Senior Member
 
Join Date: Mar 2002
Location: Switzerland
Posts: 190
rochus is on a distinguished road
Baan: xBaanxxx - DB: Oracle, DB2, SQL-Server - OS: Unix, MS, Linux
problem with more-table-selects

we got since a few days an performance problem
in session "Select Invoices for Reminding".

there's an select over tfacr200 and a 5 other tables
(full-tables-scan).
the tfacr200 has around 180000 rows.

we have incredible low perfomance in this session
(with standard-program). (runtime over 4 hours)

the os becomes very slow after starting this session.

i changed the script, so that the main-select is divided into
two parts, thirst selection tfacr200, after that i select
the other tables in selectdo.

after that the performance (runtime) is ok (~ 20 min).

we have an 3-tier scenario over oracle-sql-net
(ora 7.3.4 - i know that this version is desupported).

any help or ideas welcome.

thanks
Reply With Quote
  #2  
Old 8th March 2004, 10:53
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
rochus,

Some questions:
- can you trace what went wrong (SQL_TRACE or 10046 trace)?
- have you updated statistics?
- have you set event 100181 to 1500 or so to minimize parse time?

Probaly any of these can help.

Dick

PS what is wrong with 7.3.4?
__________________
BTW: this post has been made on my personal view. My employer might not share my point of view.
Reply With Quote
Sponsored Links
  #3  
Old 8th March 2004, 11:08
rochus rochus is offline
Senior Member
 
Join Date: Mar 2002
Location: Switzerland
Posts: 190
rochus is on a distinguished road
Baan: xBaanxxx - DB: Oracle, DB2, SQL-Server - OS: Unix, MS, Linux
i set

a)
event = "10181 trace name context forever, level 1500"
in init.ora
b)
i made update statistics, but not over all,
only these tables including indexes.
c)
tt_sql i have to try again, but i can only
do that outside rush-hour.

no problem with 7.3.4, but in one of you last statements
you remebered me to that fact (don't care)

thank you
Reply With Quote
  #4  
Old 8th March 2004, 11:18
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
Tracing

I mentioned SQL_TRACE not TT_SQL_TRACE. For detail on starting this read:
site with trace info or
my tuning and trace document

Happy tracing,
Dick
__________________
BTW: this post has been made on my personal view. My employer might not share my point of view.
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
copy records c_siek Tools Development 9 18th June 2004 16:43
Table update problem Debdas Banerjee Tools Development 3 30th October 2003 20:10
Problem with one table Haggis Tools Development 9 30th January 2002 19:18


All times are GMT +2. The time now is 18:48.


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