FiveTech Support Forums

Is COMMIT from xHarbour slower than Clippers?
Thanks in advance
Otto

Otto,

I don't know the answer but I wonder why you ask? Even if xHarbour is twice as slow, with a single commit the user isn't going to notice (0.1 seconds vs 0.2 seconds).

If you are processing lots of records there is no need to do a commit after each one--that defeats the purpose of the buffer.

Regards,
James

Otto

If you are running thru a loop of records and you do a dbCommit() each time .. you will take a tremendious performance hit.

Generally, if I am in a loop and want to do a 'hard disk' write or flush the buffer .. 'ole clipper trick' .. move the record pointer .. like goto recno() . .where recno() is the record you just updated... then after your loop .. do a dbCommit()

Hope that makes sense.

Rick Lipkin