On Aug 2, 2016, at 9:04 PM, 梨田 <[email protected]> wrote: > > I find when the data in database is larger than tens of mega bytes，it spends > more than 5~10s time to read it.
If the time required to run a given SELECT call increases linearly as a function of the database size, you’re probably doing either linear table scans or have an un-indexed query. Would you care to share your database’s schema and the queries you’re running on it? What do you get when you use the EXPLAIN QUERY PLAN feature? https://www.sqlite.org/eqp.html _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
