Performance metrics - some early conclusions

[Ruslan Zasukhin]

On 11/30/05 5:33 PM, "Ed Kleban" <Ed at Kleban.com> wrote:

>> Have you specify
>>     Table.SetBlank( forAdd )
>>                     ^^^^^^^
>> This can give 20% speedup
>> 
> 
> Yes, I recently  went through and put in "forAdd" in all my SetBlank calls.
> But since I typically do a SetBlank just once before entering a loop to set
> memory buffer fields and do an AddRecord for hundreds of records, It doesn't
> really have much affect.

In fact this is wrong.

It can kick you IF you have BLOB fields.
For BLOB fields, it is VERY important that you SetBlank() on each iteration.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]