Add Records Very Slow ?

[Barney]

Hello,

Thanks for all those suggestions.

>And whether any of fields are indexed and then which indexing. And
>that you need to actually look up since Valentina may turn indexing
>on automatically.

I never did quite understand what the heck was happening with indexing ?
It seems Valentina is just indexing automatically my databases. If I turned
them all off, next time I look they're all on again. Where does one look to
get to the bottom of all this ?

I have found the culprit. I had a Blob field (6000 segment size) in there I
was experimenting with and had forgotten to delete. With that gone it is now
humming along nicely and importing in about 5 seconds.

Thanks for all the help.

Barney




> on 2/24/03 1:17 AM, Barney at barney at custombased.com wrote:
> 
> Hi Barney,
> 
>> I am taking about 80 seconds to add 350 records to my database ? V4RB.
>> There must be a way to speed this up somehow ?
>> 
>> 
>> while NOT textInput.EOF
>> row=textInput.readline
>> 
>> 
>> for i = 1 to FCount
>> a=nthField(row,chr(9),i)
>> cur.Field(nthfield(Fnames,",",i)).setstring( a )
>> next
>> 
>> myb = cur.add()   //Offending line !
>> 
>> wend
>> 
>> textInput.close
>> 
>> 
>> If I take out the cur.add() it runs the code in about < 3 seconds.
>> With adding the records it slows down to well over a minute.
>> 
>> I have tried SqlExecute(" INSERT INTO...  with no better results.
>> 
>> I HAVEN'T tried adding data to a VField class then Bo.AddRecord yet
>> would this produce better results ?