Need suggestions pls.

[jimi]

I have a file "invoice" which store the main info of invoices(such as customer name) and another file "invoice txn" which save the content of each invoice (such as item purchased).

In an invoice, for each item in Invoice Txn, I have to run some script and decide whether I need to keep it in another file "invoice item"

If all above processes are run thr' a LAN, would it be greatly slowered because of the repetitive process? (for me it's more than 10 times slower than run in server)

thx for any suggestion

[LiveOak]

LAN operations are just slower than direct to disk operations due to the difference between a 1 MB/sec LAN and a 40 MB/sec disk interface. My only suggestion is to work on your database structure to streamline your design. You've given us no indication of what operations your script uses, so it's hard to make specific recommendations. -bd