A. Klitzing <[EMAIL PROTECTED]> wrote:
I need some information about the sqlite3_step() function.
How much CPU-usage does it need in comparison with
sqlite3_get_tables()?
The same: sqlite3_get_table is implemented in terms of sqlite3_step.
Note that sqlite3_get_table loads the whole resultset into memory, so
for large resultsets performance may suffer due to excessive paging.
#2 Way - sqlite3_get_tables()
I can use get_tables() instead and so I can set my cursor without
problems to every relative position but I loose nice features that I
have with sqlite3_stmt.
You can write something similar to sqlite3_get_tables yourself. All it
does is step through all the rows and store everything in memory.
So the question is - needs sqlite3_step() a few performance so it is
"ok" that I will iterate "dirty" through the result everytime?
I can't parse this question, sorry.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
