|Subject||Re: [Firebird-Architect] Batch/Block operations|
> > Very often appliactions repeat this stepsI talk about it. And it is 95% of all applications ;)
> >isc_dsql_sql_info (isc_info_sql_stmt_type)
> >isc_dsql_sql_info (isc_info_sql_get_plan)
> >isc_dsql_sql_info (isc_info_sql_records)
> Universal applications (connectivity drivers) - yes.
> Specialized -Of course
> no. Such applications know for sure statement type and don't care
> about plan.
> Setting name of cursor is completely pointless without followingTell it to Jeff Overcash ;)))
> '...WHERE CURRENT OF...' statements.
BTW Nickolay once said me that Java often used cursor names
> Nevertheless following suggestions are very good. EspeciallyTransaction ID. May be in the future we'll return more info about
> eliminating of isc_alloc_statement() call.
> > First step may be to merge isc_xxx_info calls into corresponding
> > xxx calls,
> >for example :
> >[isc_alloc_statement2 + ] isc_prepare + isc_dsql_sql_info
> >isc_dsql_execute2 + isc_dsql_sql_info [+ isc_dsql_set_cursor_name]
> >isc_start_transaction + isc_transaction_info
> Never used isc_transaction_info. What _useful_ information can it
transaction (for example - ID's of all participants of 2PC transaction).