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 <> 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

Reply via email to