Add Records Very Slow ?

[Ruslan Zasukhin]

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 ?

No BaseObject not help.
I don't know why is this.

Can you tell us how many fields are in your table?
What field types?
What size of db and table?
What size of cache?
What hardware?


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------