Testing shows that sqlite3_get_table is faster than sqlite3_prepare_v2 and sqlite3_step together. In fact.
At 2015-12-17 14:48:18, "Igor Tandetnik" <igor at tandetnik.org> wrote: >On 12/16/2015 11:24 PM, ??? wrote: >> There is an interesting phenomenon.As you know, SQLite can retrieve >> records by batch or one by one. >> 1.Retrieve by batch such as sqlite3_get_table. >> 2.Retrieve one by one such as sqlite3_prepare_v2 and sqlite3_step >> together. > >If you look at the implementation of sqlite3_get_table, it works by >calling _prepare and _step and so on. It's not some kind of alternative >interface to SQLite, merely a wrapper. >-- >Igor Tandetnik > >_______________________________________________ >sqlite-users mailing list >sqlite-users at mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users