[odb-users] Re: Nested vector

Andrew Cunningham andrew at a-cunningham.com
Tue Nov 24 21:57:57 EST 2015


Another approach that I have used very effectively  with SQLite is to use a
BLOB of vector<unsigned char> to store the array data.  I saw a dramatic
performance boost in my code.

 Effectively you load/save the whole BLOB -  it's data is opaque to SQL.
You may need to be aware of any alignment issues when casting a node * to
unsigned char *. And I'm not sure of BLOB size limits in postgres.


More information about the odb-users mailing list