Using bind variable with SQLite on Android

Question

Is there a performance gain when using bind variables when working with SQLite on Android? Can SQLite reuse parsed queries (like Oracle does) and thus save the SQL parsing time?

Thanks.

Alex

I do not think that it can save the parsed query because AFAIK it does the parsing each time when ever you make any query, as it does the SELECT operation and access each column. — Shaista Naaz
– Shaista Naaz, Commented May 15, 2011 at 10:32

Mike W. · Accepted Answer · 2011-09-15 16:01:42Z

1

Yes, binding variables in SQLite will give you a performance boost, as you can prepare/compile the statement a single time, then re-use it with bound variables in each iteration of your select/insert/update.

answered Sep 15, 2011 at 16:01

Mike W.

1,3758 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using bind variable with SQLite on Android

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related