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 12th January 2006, 07:51
deepaksachdeva's Avatar
deepaksachdeva deepaksachdeva is offline
Senior Member
 
Join Date: Jan 2003
Location: Mumbai
Posts: 151
deepaksachdeva is on a distinguished road
Baan: B IV c4, ERP Ln 6.1, Webtop - DB: Oracle , MS Sql Server 2000 - OS: IBM AIX 5.3,windows 2000
Performance issue after providing field level auth.

Hi all,

i am facing few issues related to performance of the session after applying the field level authorization on few users, could some one help me out how i can overcome with this.???

any suggessions/remarks will be highly appreciated.

with Regards
Deepak
Reply With Quote
  #2  
Old 12th January 2006, 21:40
NPRao's Avatar
NPRao NPRao is offline
Guru
 
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,032
NPRao will become famous soon enough
Baan: iBaanERP-5.2a(Reger),SSA-ERP-LN-6.1,Infor LN-10.x - DB: Oracle-10g,11g,12c,MS-SQL - OS: HP-UX, Linux, Windows
Deepak,

Refer to the thead - Authorisation... Does it tax the performance

Please search for existing theads for gain more insight. You have specified different BaaN versions, databases and OS in your profile, be specific to the version. Specify what kinda of table field level authorizations did you setup in the Role Data ? Are they part of indexes ?
__________________
The art of perfection does not lie in doing extraordinary things but, doing ordinary things extraordinarily well. [-N. Prashanth Rao]
How To Ask Questions The Smart Way,BaaNBoard,NPRao
Reply With Quote
  #3  
Old 13th January 2006, 00:20
lbencic's Avatar
lbencic lbencic is offline
Guru
 
Join Date: Dec 2001
Location: Lisle, IL, USA
Posts: 1,148
lbencic will become famous soon enough
Baan: 2.2d - LN - DB: most - OS: most
Also, I will add, that SSA Development is aware that field level validations cause a major slow down. In some cases, like what data do we display on the form, it's bad but not SO bad. In other cases (Baan V / Outbounding / Warehouse field level restriction), it's ridiculous, I assume because the same table with the field level authorizations is read like 50 times. In these cases, SSA Development may have a patched version with more efficient code that will lessen the problem. So, contact them with specifics as well, and make sure you have the most recent version of session code and tools/porting sets.
Reply With Quote
  #4  
Old 13th January 2006, 03:09
dave_23's Avatar
dave_23 dave_23 is offline
Guru
 
Join Date: Oct 2002
Location: Portland, OR
Posts: 1,303
dave_23 will become famous soon enough
Baan: All - DB: Oracle / MS SQL / DB2 - OS: All
Is this in Baan 5+ or Baan 4? auths are handled differently between the two veresions.

Dave
Reply With Quote
  #5  
Old 14th January 2006, 05:54
deepaksachdeva's Avatar
deepaksachdeva deepaksachdeva is offline
Senior Member
 
Join Date: Jan 2003
Location: Mumbai
Posts: 151
deepaksachdeva is on a distinguished road
Baan: B IV c4, ERP Ln 6.1, Webtop - DB: Oracle , MS Sql Server 2000 - OS: IBM AIX 5.3,windows 2000
we are using Baan IV C4

Deepak
Reply With Quote
  #6  
Old 19th January 2006, 16:02
Hitesh Shah's Avatar
Hitesh Shah Hitesh Shah is offline
Guru
 
Join Date: Nov 2001
Location: Mumbai,India
Posts: 1,855
Hitesh Shah is on a distinguished road
Baan: triton,Baan IVc4 , ERP Ln - DB: Oracle/Bisam/SQL 2000/SQL 2005 - OS: Sun Solaris/Windows 2003
field level authorization

Hi Deepak ,

We had tried to use field level authorization but left the idea due to poor performance. We are managing the authorizations through sessions only .
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
Performance issue on SQL-queries en@frrom Tools Development 17 23rd September 2003 10:18
field level restriction REETA1967 Tools Development 2 14th January 2003 18:20
Mandatory field at form level BaanTech Tools Development 3 20th September 2002 17:14
Access/field entry control at field level pjohns Tools Development 5 25th April 2002 16:26
Oracle level 2 performance richard Performance & Tuning 8 11th October 2001 18:34


All times are GMT +2. The time now is 02:52.


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