> On Oct 16, 2019, at 6:08 AM, Mitar <mmi...@gmail.com> wrote: > > Quite > some of datasets we are dealing with have 100k or so columns.
There was a thread about this a few months ago. You Should not store every number of a huge vector in a separate column. You don’t need to individually query on every individual item, do you? Just store the vector as one column — JSON works well, or a blob containing a C array. —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
