Go Back > Forum > CMS - Forum Integration > Blogs and Web links

User login

Frontpage Sponsor


Google search

For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
Installation Wizard into new VRC
Manual into existing VRC
Manual into new VRC
Total votes: 39

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 28th May 2009, 08:57
bhuvaneshwari bhuvaneshwari is offline
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

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.

Last edited by bhuvaneshwari : 28th May 2009 at 12:49. Reason: optimized the question
Reply With Quote
Old 29th May 2009, 12:30
bdittmar's Avatar
bdittmar bdittmar is offline
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,683
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

Originally Posted by bhuvaneshwari View Post



long db.clear.table( long table_id [, long flag [, long comp_nr]] )
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.

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:

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

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.

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
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 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 markom Operating Systems & Databases 4 23rd July 2003 15:01

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

©2001-2017 - -