Subject | Re: [firebird-support] Strange performance problems |
---|---|
Author | Tim Ledgerwood |
Post date | 2003-12-04T08:26:37Z |
>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
>is saved
>and then gathering of sales data and then updating the sales data that was
>inserted ?
>
>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.
Thanks
Tim
[Non-text portions of this message have been removed]