Thanks for all the responses. The small integer column H11 comes before the large string column NVERTS, so doesn't that mean SQLite is only loading the minimum required while filtering? If that's the case then I don't understand why it's taking up to 15 minutes to load.
Also, yes this database is local, and not being read over a network. Best, Ross On Sat, Oct 25, 2014 at 9:15 AM, Richard Hipp <d...@sqlite.org> wrote: > On Sat, Oct 25, 2014 at 9:14 AM, Stephen Chrzanowski <pontia...@gmail.com> > wrote: > > > Ahh.. Thanks Richard. So if you were to have blobs live at the front of > > the row, it'll have to read through that blob to get that byte in the > next > > field, correct? > > > > > Correct. > -- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
