Login
Templates, Tools and Utilities
for Clarion Developers
Templates, Tools and Utilities
|
||
|
|
|
Add a comment to an Icetips ArticlePlease add your comments to this article.
Please note that you must provide both a name and a valid email address in order
for us to publish your comment. Comments are moderated and are not visible until they have been approved. Spam is never approved!
Back to article list Search Articles Add Comment Printer friendly Direct link Par2: Batch adding records 2008-08-24 -- Paul Howard Yes, for TPS, LOGOUT/COMMIT every 1000 records or so is faster than
STREAM/FLUSH every 1000 records, and works on shared files. Avoid this
tight loop for anything but small sets of adds cus it will be unfriendly
towards other processes and users and there is no way to bail, no screen
refreshes, etc. Use the report or process template and add a
logout/commit every 1000 records. Add LOGOUT after parent.OpenReport if
returnvalue = 0 (yes, there is an OpenReport in Process!), add
COMMIT,LOGOUT after parent.TakeRecord when (SELF.RecordsProcessed %
1000) = 0) and add final COMMIT in TakeCloseEvent. FWIW, I have an
include file that is used to copy all records between two files and
rebuild keys with progress and bailout using a timer. It's very fast
and includes an option to use either stream or logout. STREAM is faster
than LOGOUT on Btrieve and maybe other drivers. TPS LOGOUT is very fast
as long as you commit in chunkes.
Today is November 21, 2024, 6:37 am This article has been viewed 35216 times.
|
|