On 6/11/2013 9:01 AM, Simon Slavin wrote:
The only time that _prepare() will use a lot of memory is when it has to generate a temporary index because you have not created a table index suitable for the WHERE and ORDER BY clauses.
I'm pretty sure this would happen on the first _step(), not on _prepare(). Prepare is always nearly instantaneous.
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
