Baanboard.com

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

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
17%
200 - 500 GB
26%
500 - 800 GB
3%
800 - 1200 GB
9%
1200 - 1500 GB
11%
1500 - 2000 GB
14%
> 2000 GB
20%
Total votes: 35

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 28th February 2004, 07:26
grajenda grajenda is offline
Member
 
Join Date: Feb 2004
Location: The Great India
Posts: 74
grajenda is on a distinguished road
Baan: baanIV baan V and SSA ERPLN - DB: SQLServer - OS: windows 2000 server
Diff btw....

Hai gurus,
I would like to know the difercene in putting a commit.Transaction in selecteos clause and after endselect clause

Thanks in advance
James
Reply With Quote
Sponsored Links
  #2  
Old 28th February 2004, 10:09
Hitesh Shah's Avatar
Hitesh Shah Hitesh Shah is offline
Guru
 
Join Date: Nov 2001
Location: Mumbai,India
Posts: 1,853
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
difference

Selecteos( end of search) comes only if there is at least 1 record in the select query and complete selection is processed for all records selected . So if u break in selectdo , it will not execute selecteos statements .

So commit transaction in selecteos will gets executed only in the condition specified where the commit after endselect will always be executed.

In order to improve the performance generally the commit transaction is done after updating about 50 records . Also it depends on where u put db.retry.point also and whether you wish to abort.transaction based on some conditions or not .
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
What is the diff? jack786 Tools Development 2 2nd July 2004 17:00
Diff between two date time fields BigJohn Tools Development 3 17th April 2004 19:49
Diff btw Oracle Level-1 and Level-2 drivers grajenda Operating Systems & Databases 1 29th February 2004 05:32
What makes diff? grajenda Tools Development 2 24th February 2004 19:21
Slow Moving for diff warehouse zhuowb Distribution, Transportation & Warehousing 2 10th October 2003 07:50


All times are GMT +2. The time now is 07:06.


©2001-2018 - Baanboard.com - Baanforums.com