Ben, It's how I do it. When I load the files , I use a temporally tables, different for each computer. But I think the problems is when you do more than one load at same time in one DataBase . I think that because before now, I was using separate DB to do it and it was perfect. Now we have a only one DB and we have locks when use more than one PC at same time (with differents tables)
On Wed, 10 Sep 2003 14:39:40 -0700 "Ben Petersen" <[EMAIL PROTECTED]> wrote: > 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 > > > Best regards Ramon Guardiola fermatic Three system
