Baanboard.com

Go Back   Baanboard.com > Forum > CMS - Forum Integration > Blogs and Web links

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 28th May 2009, 08:57
bhuvaneshwari bhuvaneshwari is offline
Newbie
 
Join Date: May 2009
Posts: 1
bhuvaneshwari is on a distinguished road
Baan: B40c.80 - DB: oracle - OS: Windows XP Professional
Delete Millions Of Records with Less Time and Performance

A new blog entry has been added:

Delete Millions Of Records with Less Time and Performance

Quote:
Hi,
We have a session which is used to delete the rows in the table. It has 5 sections and each sections takes more time to delete the Millions of records and are executed one by one . And now we need to delete all the records in less time.
Any suggestion on what could be done delete the records with less time will be very much help full for us.
 
Thanks,
Bhuman 

Last edited by bhuvaneshwari : 28th May 2009 at 12:49. Reason: optimized the question
Reply With Quote
Sponsored Links
  #2  
Old 29th May 2009, 12:30
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,653
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox - DB: tbase, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
db.clear.table() will do the job

Quote:
Originally Posted by bhuvaneshwari View Post
Hello,

db.clear.table()

--------------------------------------------------------------------------------

Syntax
long db.clear.table( long table_id [, long flag [, long comp_nr]] )
Description
This deletes all data from a specified table. Reference counters are automatically updated.

By default, all deleted records are saved in rollback segments. Consequently, using this function to clear a large table can result in reduced performance and, in some cases, can cause overflow of the internal rollback segments.

Arguments
table_id
The table ID, as returned by db.bind().

flag Use this optional argument to indicate whether the delete operation must be performed as a single transaction or as multiple transactions. The possible values are:

0 WITH.ROLLBACK
The table is cleared in a single transaction. All records are saved in rollback segments. This is the default option.

1 NO.ROLLBACK
The table is cleared in one or more transactions, depending on the number of records in the table. Each transaction is automatically committed after 20 records have been deleted. The number of records deleted in the final transaction can be 20 or less; this depends on how many records remain to be deleted.

When you use this option, transactions are small and records are not saved in rollback segments.

When you use this option, you must place db.clear.table() at the start of the transaction.


comp_nr
This optional argument specifies a company number for the table. The default company is the company of the user.


Return values
0 success
<>0 error
__________________
//Bernd
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 On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
performance dll Hitesh Shah Code & Utilities 11 2nd March 2009 14:29
Performance issues after migrating to O9 Markus Schmitz Operating Systems & Databases 36 4th July 2004 12:21
Degrading performance over time of HP-UX boxes with IVc4 chadwickh Operating Systems & Databases 8 29th September 2003 19:55
Performance issue on SQL-queries en@frrom Tools Development 17 23rd September 2003 10:18
BaanIV, NT and Oracle 8.1.7.3 markom Operating Systems & Databases 4 23rd July 2003 15:01


All times are GMT +2. The time now is 15:50.


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