S D
accessd667 at yahoo.com
Fri Oct 29 02:23:02 CDT 2004
I didn't mean to say that Novell has slow networks but this one is! "a bottleneck"?? We've got several crates full of bottlenecks :-) Gustav Brock <gustav at cactus.dk> wrote: 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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com --------------------------------- Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish.