>>>>>>>>>>>>>>>>
> I am developing a multi-user POS system using VFP database. Our design is to place the database in a hign end PC, all of the workstations will shared the table located in server.
> It need to update 4 tables for each transaction. Again, the are about 5-10 users will access to the server at this moment. However, will be grow very soon.
> Which is the better way to update the sales transaction, online or batch processing?
>
>Online : Connect to server database and TABLEUPDATE() immediately once the sales done.
>Batch : Update in local table, and process these local records at the end of the day to update the server datanase.
>
>I have think of some adv and disadv of both method.
>I would like to get your recommendation too!!
>>>>>>>>>>>>>>>>
What are your requirements? If you need to have the data up to date, inventory updated, etc. in close toreal time, then you want to update immediately.
Besides, it does not sound like a online updating will slow you much. I don't see the point of using batch here.