The databases I make are pretty darned small and insignificant that even full table scans wouldn't show that much of a hit in performance. However, if there were an API or SQL code or something we can add to our code that would give you meaningful results (other than "Yes, it works") we could email in, I'd be glad to add it in for debug executions.
On Wed, Oct 4, 2017 at 1:30 PM, Richard Hipp <[email protected]> wrote: > > But, I'd like to get more real-world feedback on the use of "PRAGMA > optimize" and how well it works (or doesn't work) for a wider spectrum > of developers before I start pushing it as a recommended solution. > > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
