|Subject||Re: [firebird-support] Strange performance problems|
>Nope - that's cool - it's not easy to explain an app over email. :-D
>Now if understood correctly the slow part is the FIRST part where the data
>and then gathering of sales data and then updating the sales data that was
>Sorry for my ignorance :).
The slow part is the SECOND part - where the gathering of the sale data,
updating the financial transaction in the DB, and inserting the amount
tendered as a financial transaction in the DB. These last two things -
updating and inserting the amount tendered - occur in ONE database transaction.
All of this is controlled from the client - although the update and inserts
are stored procedures which are called by the client.
[Non-text portions of this message have been removed]