Subject Re: [firebird-support] Strange performance problems
Author Tim Ledgerwood
>
>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 :).

Nope - that's cool - it's not easy to explain an app over email. :-D

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]