Subject | Re: [Firebird-Architect] Batch/Block operations |
---|---|
Author | Vlad Horsun |
Post date | 2005-02-21T21:25:03Z |
> The protocol reflects the API. Do you have any suggestions for reducingVery often appliactions repeat this steps
> the number of round trips?
isc_alloc_statement2
isc_prepare
isc_dsql_sql_info (isc_info_sql_stmt_type)
isc_dsql_sql_info (isc_info_sql_get_plan)
isc_dsql_execute2
isc_dsql_set_cursor_name
isc_dsql_sql_info (isc_info_sql_records)
...
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
Regards,
Vlad