[AccessD] pls advise: Performance problem => Staging + UpdateBatch? *SOLVED*

Hi Sander

Nice!

However, if it adds 11 seconds to read a 250K file off the network
compared to read it from local disk, it is not a "slow Novell network"
just a slow network where something represents a bottleneck which
needs an upgrade.

/gustav


> Jim, Gustav,
 
> thnx for the replies.
> However, while I was 'fondeling' around I was looking at the code, network stats, doing some prototyping I came up with the following.
> Load the file (wich I first copied to the desktop) in an array;
> then I opened 3 rsts
> Then I loop-ed through the file until the UBOUND(array) was found
>   did a addnew + update after each found 'tag'
> exited the loop,
> closed the rsts
> and voila! Remember the 25 hours.....how about 3 seconds!!!
> Then I skipped the copying part and left the file on the network, still 14 seconds. Maybe it can be done faster but I think a 50,000% performance improvement will do just fine :-)
 
> The problem was that the 'programmer' that designed and build the app did the following:
> While looping through the file he opened and closed a recordset every time he found a 'tag' So that could be about 5500 times! Over a slow novell network using a 800Mb Fe-Be app....
 
> Well it works. Now all I have to do is create the transaction thingy Gustav said. Just read about it in the bible...aka ADHB2K by litwin, gilbert and getz...get it ;-) Sjee, it's getting a bit late.
 
> Sander