Martin Pelletier <mp-PCTmRokFnwWw5LPnMra/[EMAIL PROTECTED]> wrote:
I am using an SQLite to host data for various projects, some of which
take up significant place with some large monolithic tables (around
750 MB). Querying goes through the DLL using a call to
SQLite3_get_table.
The function allocates memory space to record the table in chars, even
if the original field is numeric. Is there a similar function that
would place the result of a query in memory just like SQL3_get_table
but
their stored type (integer, float, etc), with perhaps a header to
indicate
what type the data should be read as?
With SQLite's manifest data type system, this is, in general,
impossible. Consider:
select id, (case when id%2 then 'odd' else 0 end) as tricky
from mytable;
In the "tricky" column, you would have some rows with string data and
some with an integer.
See sqlite3_prepare[_v2], sqlite3_step, sqlite3_finalize,
sqlite3_column_*
Also, could this data be
arrayed? It would seem that reading an array from memory of length n
would be
faster than reading separately n pointers.
I don't understand this question, sorry.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
