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 15th December 2004, 16:44
vishbaan's Avatar
vishbaan vishbaan is offline
Senior Member
 
Join Date: Aug 2001
Location: Dubai
Posts: 207
vishbaan is on a distinguished road
Baan: B40c4, LN - DB: SQL2K - OS: W2K
Authorisation... Does it tax the performance

Dear Fnds,

In our installation B40c4/SQL2000/WIN2000,

in general the system is overall very slow.

I found the table data autorisation have Read , Not authorised authorisations spread on many tables like tdsls041, tdpur041, tdrpl100 etc.. on fields like cwar, order type etc.. totally 30,000 authorisation records are there.

Will it tax the system, how to find out its load..

will appreciate your inputs

thanks

VISH
__________________
Vishi...Cool
Reply With Quote
  #2  
Old 15th December 2004, 18:32
Francesco's Avatar
Francesco Francesco is offline
Guru
 
Join Date: Aug 2001
Location: Antwerp, BE
Posts: 727
Francesco is on a distinguished road
Baan: 5b - DB: Oracle - OS: Solaris
Thread moved

Thought this one might get better response in the performance platform.

I'm not sure that I understand the issue though. Are you seeing a lot of attempts to read tables without authorization?

That in itself should have no significant performance implications.
__________________
Cheers,

Francesco
..............................................................

Admiral Business Solutions | My World | Baan Board | IT Happens!

"If everyone is thinking alike, then somebody isn't thinking" -- George Patton
"It's easy to cry 'bug' when the truth is that you've got a complex system and sometimes it takes a while to get all the components to co-exist peacefully." -- Doug Vargas
Reply With Quote
  #3  
Old 15th December 2004, 19:58
p.cole's Avatar
p.cole p.cole is offline
Senior Member
 
Join Date: Nov 2001
Location: Portsmouth, UK
Posts: 265
p.cole is on a distinguished road
Baan: Baan IVc4 SP20, ERP LN FP3 - DB: MSSQL 2005 - OS: W2K3
Table data authorisations are killers for performance. Avoid them at all costs on non-key fields. Saying that we have segmented a range of our users from other users on a range of sales order numbers (tdsls040.orno) and project series (tipcs020.cprj) without too much performance impact
Reply With Quote
  #4  
Old 16th December 2004, 16:57
vishbaan's Avatar
vishbaan vishbaan is offline
Senior Member
 
Join Date: Aug 2001
Location: Dubai
Posts: 207
vishbaan is on a distinguished road
Baan: B40c4, LN - DB: SQL2K - OS: W2K
on the authorisation

hi

hello Frances :
to rephrase my question,
we have defined a lot of table data authorisation;
Eg:
not to be able to access the Warehouses(which are no longer operational) by any user, during purchase, sales and RPL etc.

hello Cole,
thanks,
will authorisation act as a display filter like the
main.table.io:
after read:
if tbl.cwar <> auth.cwar then
skip.io("")
endif

Then it will be really taxing..

wishes

VISH
__________________
Vishi...Cool
Reply With Quote
Sponsored Links
  #5  
Old 16th December 2004, 20:58
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
Quote:
I found the table data autorisation have Read , Not authorised authorisations spread on many tables like tdsls041, tdpur041, tdrpl100 etc.. on fields like cwar, order type etc.. totally 30,000 authorisation records are there.
Vish,

Thats indeed a lot of settings. We have implemented table field data authorization for tools but not for the application tables and I am on a different BaaN version. But I heard that it helps wrt performance of the bshell.

Quote:
will authorisation act as a display filter like the
main.table.io:
after read:
if tbl.cwar <> auth.cwar then
skip.io("")
endif
If it acts so then its a performance hit I think it adds conditions to the "where" clause so the invalid records are not fetched.

The problem might be somewhere else on the Oracle tuning, OS parameters etc. Search for other threads about performance and use the bshell options (profiler, dbslog, TT_SQL_TRACE, BLAT etc) to trace the real issue.
__________________
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

Last edited by NPRao : 16th December 2004 at 21:15.
Reply With Quote
  #6  
Old 17th December 2004, 20:20
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
Depends on what version of Baan. In Baan 4, it fetches all of the data but doesn't display it. In Baan 5 it modifies the "where clause". Naturally in
Baan 5 you have a better chance of it Not hurting performance - but you sort of have to look at it on a table by table, query by query basis..

In Baan 4 its more consistant, but also you've got a bunch of rules applied to each record before it is displayed..

Dave
Reply With Quote
  #7  
Old 22nd December 2004, 16:11
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
Nothing news

I think I add nothing news, but maybe it helps.

Authorisations can become performance killers when:
- checks are done on not index fileds
- many checks are done (like your 30.000 or so ) on index fields

On whatever way you implement it, performance can never become optimal if any of above is implemented.

In older portingsets there where some issues that also could lead to bad performance even when above rules where not met.

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
  #8  
Old 23rd December 2004, 08:45
vishbaan's Avatar
vishbaan vishbaan is offline
Senior Member
 
Join Date: Aug 2001
Location: Dubai
Posts: 207
vishbaan is on a distinguished road
Baan: B40c4, LN - DB: SQL2K - OS: W2K
if it is a warehouse fied

dear d'k

if let us say the requirement is:
"No user should be able to use a warehouse code X00 (businesswise now its a dead warehouse which was earlier operational)".

if on index how will I be able to restrict the users:
while creating POs (tdpur040/041 tables)
while creating SOs (tdsls040/041 tables)
while creating RPLs (tdrpl105/100 tables)

if you get any other clues for obtaining the above requirement other than table data authorisation, u r welcome. (I wish there were blokcings, active, non-active fields and functionalities available for warehouses too..like the item signal code....I could have blocked all the locations of the said warehouse but it still allows the users to create PO/SO and all.)

thanks and best regards

VISH
__________________
Vishi...Cool
Reply With Quote
  #9  
Old 23rd December 2004, 09:29
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
Beside the Baan way, you can try to create a view on the table with the restrictions. Then you don't see the record anymore if that is ok to you. But be very carefull as it interfears with baan components for reorganisation etc.

Kind regards,
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
Deduction Tax Mohamed_alsadr Finance, Invoicing and Integration 4 9th June 2005 20:04
Tax on Service contract shaboo Project & Services 0 29th July 2004 17:29
Finalization Error when Posting a Sales tax avpatil Finance, Invoicing and Integration 2 31st October 2003 20:03
About tax type Ucanyu Finance, Invoicing and Integration 3 8th January 2003 12:05
tax problem parames Distribution, Transportation & Warehousing 0 18th July 2002 06:57


All times are GMT +2. The time now is 13:19.


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