SiebelGuide.com/siebelblogs

Siebel Blogs, News, Events, Tips and Tricks
Filed under Tips&Tricks, eScript, All

There is definitely scripting involved in any Siebel implementation but is safe not to clutter with scripting. As a developer s/he has to always think about the performance impact as it could result in significant downgrade of the system.

So here are few more best practices on Siebel eScripting.

Tip5:
Totally Avoid Scripting on Frequently Fired Events like PreGetFieldValue and ChangeRecord Event.

PreGetFieldValue event is triggered for every column under every record that is retrieved. For instance if there are 10 records retrieved in an applet and there are 10 columns or values in each record then this event will be fired 100 times. This is a big number and could grow dramatically. So it is a big NO NO for scripting on this event.
ChangeRecord event is triggered every time a user navigates to the next record. This will slow down the user completely. Users would complain and if somewhere this BC is used for scripting anywhere else, then this event will impact the performance that scripts. So be very careful as this is definitely not recommended.

Tip6:
Browser Script causes burden on the application to load. So heavy browser scripting should be avoided. Additionally use only for simple client side functionalities like validating values. Also avoid browser scripts that require server side roundtrip to get fast response. For example, fetching values from the server database back into the browser script would take time and would result in slow response.


Tip7:
When you use ExecuteQuery() in eScripting, by default it uses ForwardBackward mode where in it remember the past record and would use some resources. Instead use ForwardOnly cursor mode wherever possible as it improves performance by not having to remember the past records that have already passed. By default it is ForwardBackward and you will have to specify the cursor mode to use as ForwardOnly like in oAccountBC.ExecuteQuery(ForwardOnly).

I hope that these tips are helpful. I will be adding more in the future.

Let your friends know about this website. If you know any other helpful Tips then please share with me and others.

As usual subscribe to my blog via RSS or email to get notified about new posts.

Related posts(Auto Generated):

  1. eScript Best Practices - Part6
  2. eScripting Best Practices - Part3
  3. eScript Best Practices - Part7
  4. eScripting Best Practices - Part1
  5. eScripting Best Practices - Part2

Posted by Sridhar on Wednesday, January 30th, 2008


Page copy protected against web site content infringement by Copyscape
You can follow any responses to this entry through the magic of "RSS 2.0" and leave a trackback from your own site.

5 Responses to “eScripting Best Practices - Part4”

Post A Comment

Recent Posts 

Recent Comments:

  • Gloria: Thank you for sharing your knowledge!
  • Sridhar: Hi Satya, Please share your documents using “Participate” link on the right hand side. Many thanks...
  • satya vardhan: hi ramya this is vardhan i am in obiee developer i am not undrstanding ur query can u repeat once again...
  • satya vardhan: hi sri obiee this is reporting tool if u want more details send me ur mailid. i can forword some documents...
  • Ramya: Hi, Can u pls tell me how to get the difference between two date fields by ignoring weekends (i.e satday, sunday if...