views:

44

answers:

1

Are there any good SQLite profilers? I need something similar to what JetProfiler offers for MySQL. I've found a 3-year-old blog post - any other ideas?

+1  A: 

SQLite includes an experimental Tracing And Profiling C API.

Doug Currie
Not really what I am looking for... I am not that interested in details about what happens while executing a single statement, what I need is a tool that just looks which statements take long and runs EXPLAIN on them.
Michael Pliskin
The callback function registered by sqlite3_profile() is invoked as each SQL statement finishes. The profile callback contains the original statement text and an estimate of wall-clock time of how long that statement took to run.
Doug Currie