[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