i want to know about how transction works and how can i optimise my c/s programs with this.
i have firebird 1.5.0.421
at present i have got this
read_committed
rec_version
nowait
SHARED
in transaction component. it some times gives deadlock on some views.
how to improve it.
will this work ? (it is giving error in delphi/ ibx )
read write
nowait
read_committed rec_version
shared read