Go Back > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor


Google search

How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 40

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 30th October 2003, 13:34
kv0512's Avatar
kv0512 kv0512 is offline
Junior Member
Join Date: Mar 2003
Location: Mumbai
Posts: 9
kv0512 is on a distinguished road
Baan: IVc,ERP - DB: Oracle 9i - OS: unix
Performance issue

Dear All
I need to improve the performance of one off my custmized session . what all need to be check for performance improvement ?

Pls help


Reply With Quote
Old 30th October 2003, 13:56
kbartelds kbartelds is offline
Senior Member
Join Date: Feb 2003
Location: Netherlands
Posts: 264
kbartelds is on a distinguished road
Baan: B40c4 - DB: Oracle 7 - OS: Sun Solaris

If the performance problem is for one specific session, first thing to do is to check all select statements, specially the ones for larger (>1000 records) tables. Usually the problem is a where clause on index without specifying order by, this can result in full table scans. If you post your script, it can be checked.

Best regards,
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
Intermittent performance issue tfacp2120s000 rosalbaperez Performance & Tuning 1 25th March 2003 10:11
Performance Issue... suhas-mahajan Performance & Tuning 2 18th March 2003 17:01
Performance Issue... r_nagu Performance & Tuning 4 19th February 2003 17:57
Performance issue while running DNC ! mraguthu Distribution, Transportation & Warehousing 0 1st April 2002 23:31
Performance issue while running EDI-DNC to create Sales Orders. How I resolve? mraguthu Tools Development 0 28th March 2002 20:08

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

©2001-2018 - -