Go Back > Forum > Baan SIGs > Performance & Tuning

User login

Frontpage Sponsor


Google search

For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
Installation Wizard into new VRC
Manual into existing VRC
Manual into new VRC
Total votes: 49

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 19th December 2002, 06:39
ramakrish's Avatar
ramakrish ramakrish is offline
Unconfirmed User
Join Date: Oct 2002
Location: India
Posts: 100
ramakrish is on a distinguished road
Baan: BaaN IV,BaaN ERP - DB: oracle - OS: NT
system slow during Transaction processing & Report Printing

One of our client running BaaN IV IS4 on NT/SQL server with 15 user Licenses. The site went live Just two months to date.
During the Maintain Transaction (finance)session processing and Printing the Reports like Print Purchase Order, system becomes slow and it is taking a lot of time (about 10-15 min).

what can be the problem...if anybody come across this kind of problem, pls advise us.

Thanks in ADvance.

Reply With Quote
Old 19th December 2002, 12:57
OmeLuuk's Avatar
OmeLuuk OmeLuuk is offline
Join Date: Mar 2002
Location: The Netherlands
Posts: 1,075
OmeLuuk is on a distinguished road
Baan: Infor LN 6.1 10.2.1 - DB: MS SQL2008 - OS: VM WindowsServer2008R2

One of the points you have to check is: does SQL server use both processors (if present) in the server? There is a setting for that. Do not ask me which setting it is...

It may be that some database tuning or optimizations are required. Also software can be the problem, but is not that likely to be. If so, then other Baan users would complain also and very bad performance will result in better performing software. It is however possible that changes to enhance the speed on a Level II database driver (such as Oracle) will decrease the speed on a Level I database (such as SQL).

You can run the session with various loggings (TT_SQL_TRACE=0240 to start with) to see where the performance gets lost.

Also the use of sessions (selections given) can cause bad performance: usually the form of a session is built up using index 1 on the main table. So if the first (key)fields are not used, and the last (key) fields are used, then the session should actually pick another index instead (having these last fields filled on the form as first fields in the index to reduce dataload by the database driver), but this normally does not happen (needs a lot of ugly programming to have it working for all possible choices). So try to run with tight selections as much as possible.
Also read Luke 24:4-8
Reply With Quote
Old 19th December 2002, 14:14
Neal Matthews's Avatar
Neal Matthews Neal Matthews is offline
Join Date: Sep 2001
Location: Nottingham
Posts: 483
Neal Matthews is on a distinguished road
Baan: Baan IVc4 ags0 - DB: Informix 9.40 UC4 - OS: Sun Solaris 9
With regards to Maintain Transactions it may be worth checking how many records tfgld102 has in it.

We had a lot of problems early on which dissapeared when we encouraged users not to leave a lot of unfinalised batches.

Hope this helps
Reply With Quote
Sponsored Links

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
Report Processing Time Slow teddy_pean Tools Development 3 7th May 2002 09:24
Report Processing Time Slow teddy_pean Tools Development 0 6th May 2002 10:08
tfacp9450m000 FIBU Brush Up Kai's Forum Users Deutsches Forum 1 16th November 1999 00:00

All times are GMT +2. The time now is 11:04.

©2001-2018 - -