ken-33 <[EMAIL PROTECTED]> wrote: > Anyone thoughts? > I would rather not complicate the existing API unnecessarily by add bells and whistles that can be easily implemented using simple by wrappers.
> > ken-33 wrote: > > > > Question for the list, > > > > I'd like to optimize my code, using the following pseudo code as an > > example. > > > > =================================== > > int i = 0 ; > > char str[20]; > > > > sqlite3_prepare_v2( "insert into t1 values (?,?)" ) > > sqlite3_bind_int ( i ) > > sqlite3_bind_text(str) > > > > BEGIN TRANSACTION > > For (i = 0; i < 10; i++) { > > sqlite3_step ( ); > > sqlite3_reset( ) > > } > > COMMIT TRANSACTION > > ====================================== > > > > However, the above code will fail to insert the values for i in the loop. > > It will only insert the value 0, since that was the binding value... > > > > An enhancement request would be to allow the user to bind the address to > > the statement objects. This would be a huge benefit from the standpoint > > of fewer function calls to sqlite3_bind in the inside loop. > > > > So maybe the following API: > > > > sqlite3_pbind_int(sqlite3_stmt *, int, int * ); > > sqlite3_pbind_int64(sqlite3_stmt *, int, long long int * ); > > sqlite3_pbind_double(sqlite3_stmt *, int, dobule *); > > sqlite3_pbind_text(sqlite3_stmt, int, const char *, int *, > > void(*)(void*)); > > notice the text takes a pointer to the length... > > sqlite3_pbind_blob(sqlite3_stmt*, int, const char *, int *, > > void(*)(void*)); > > > > Concept of SQLITE_STATIC vs SQLITE_TRANSIENT is implied that all data is > > SQLITE_STATIC. > > > > Regards, > > Ken > > > > > > > > > > > > -- > View this message in context: > http://www.nabble.com/API-enhancement-tf3405347.html#a9562311 > Sent from the SQLite mailing list archive at Nabble.com. > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > > . ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------