Hello,
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? 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.
This could have an impact as the language I am using that calls the
SQLite3.dll is an interpreted language (www.jsoftware.com), which has to
re-evaluate all the strings to put them back in integer or float type,
an operation which could be considered a loss in performance.
Regards,
Martin
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
