Understanding this section do you have a client saving data to the database
then a Service
in the background doing business transactions on the data saved. Or does the
client save the data and then gathers the sale data from the POS, then
updates the inserted
sale with the POS data. And then a final process is made when the amount is
payed ?

Now if understood correctly the slow part is the FIRST part where the data
is saved
and then gathering of sales data and then updating the sales data that was
inserted ?

Sorry for my ignorance :).

>Our application runs on Interbase 6.02, and is a POS system for service
>(petrol and diesel) stations. As such, it inserts new transactions and
>commits them, gathers the sale data from the POS, then updates the inserted
>sale with the POS data. Finally, when the client settles the amount owing,
>the application inserts the amount tendered as a transaction.

----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003


[Non-text portions of this message have been removed]