Ramon, You are right, I don't think you can do simultaneous "load"s to the same table. I can imagine a number of ways to accomplish this, but the simplest would be to have the invoices loaded by a single computer, rather than 4. Even 5,000 shouldn't take very long. If that is not practical, you will probably need a separate table for each computer and consolidate them at the end. Otherwise each will have to wait its turn which would end up taking as long as one computer doing all the invoices.
Ben Petersen On 10 Sep 2003, at 22:30, [EMAIL PROTECTED] wrote: > Firts of all, tx for all your answers on my question about locks in > R:Base. > > This question is on the same way, because I read my code with your > suggesttions but I think my problem come from another think. > Firts I explain my situation: > > The apx files are compiled in Rbase 6.5 ++ and executed with Rtime > unlimited. We are using a NT server/ W2000 and 10 PC's workstations > with W98. > During the normal work all are good, the problems we have with the > "nigth process" this process collect invoices, process orders, > stadistics and so on. > > We collect invoices from our PDA (about 300 PDA #invoices around 5000 > per day). The data comes in ascci files and we use instruccions like > LOAD &tdv FROM &vout4 to do it, where &tdv is a different temporary > table for each sales office (up to 10) we process that using 4 PC's, each > PC process one different sales office at time. > Like all is using differents tables my only point that I think maybe > it's the cause of the message "waiting to access to a required resource 25%" > and keeps until I push cancel button is the LOAD instruccion. > > Maybe there's a limit to simultaneous LOAD (ascii files)? and haw can I > solve that? > > > Best regards, > > Ramon Guardiola > fermatic Three system >
