[sqlite] sqlite3 (or sqlite4) performance on NFS

2015-04-12 Thread Howard Chu
Stephen Chrzanowski wrote: >>From what I understand; > - Read-Only data > - Data doesn't change frequently > - Central repository for data > - Network latency causing issues > > My two cents on this is to keep a database revision ID kicking around and > do a SQLite backup of the remote data to a

[sqlite] sqlite_column_blob & invalid index

2015-04-12 Thread gwenn
Ok, Thanks. On Sun, Apr 12, 2015 at 2:08 PM, Stephan Beal wrote: > On Sun, Apr 12, 2015 at 2:04 PM, gwenn wrote: > >> Thanks for reply. >> Could you please elaborate ? >> For me, there is no way to know if the specified column index is >> invalid by using the column value returned by >>

[sqlite] sqlite_column_blob & invalid index

2015-04-12 Thread Stephan Beal
On Sun, Apr 12, 2015 at 2:04 PM, gwenn wrote: > Thanks for reply. > Could you please elaborate ? > For me, there is no way to know if the specified column index is > invalid by using the column value returned by > sqlite3_column_blob/text/int . > i was mistaken: the docs say: "If the SQL

[sqlite] sqlite_column_blob & invalid index

2015-04-12 Thread gwenn
Thanks for reply. Could you please elaborate ? For me, there is no way to know if the specified column index is invalid by using the column value returned by sqlite3_column_blob/text/int . Regards. On Sun, Apr 12, 2015 at 11:50 AM, Stephan Beal wrote: > On Sun, Apr 12, 2015 at 11:48 AM, gwenn

[sqlite] sqlite_column_blob & invalid index

2015-04-12 Thread Stephan Beal
On Sun, Apr 12, 2015 at 11:48 AM, gwenn wrote: > Hello, > Could you please tell me if sqlite3_errcode/sqlite3_errmsg should be > called after each call to sqlite3_column_blob/text/int/... to check > that the column index is valid ? > Not needed - simply check the result code of your call to

[sqlite] sqlite_column_blob & invalid index

2015-04-12 Thread gwenn
Hello, Could you please tell me if sqlite3_errcode/sqlite3_errmsg should be called after each call to sqlite3_column_blob/text/int/... to check that the column index is valid ? I am confused by: > http://sqlite.org/rescode.html#range > The SQLITE_RANGE error indices that the parameter number