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

User login

Frontpage Sponsor


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: 54

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 28th February 2004, 07:26
grajenda grajenda is offline
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
Reply With Quote
Old 28th February 2004, 10:09
Hitesh Shah's Avatar
Hitesh Shah Hitesh Shah is offline
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

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
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
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 10:31.

©2001-2018 - -