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 <[email protected]> wrote: > On Sat, Oct 25, 2014 at 9:14 AM, Stephen Chrzanowski <[email protected]> > 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 > [email protected] > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
