Re: [sqlite] SQLite Profiler

2012-03-30 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 30/03/12 01:45, TeDe wrote: > We 've been using profilers for Sybase and MySQL, where you can see a > lot more: index usage, number of page reads, returning rows and time - > for the whole query and for every subquery. Note that SQLite runs as a

Re: [sqlite] SQLite Profiler

2012-03-30 Thread Simon Slavin
On 30 Mar 2012, at 9:45am, TeDe wrote: > is anyone aware of a profiler for SQLite? I know the "Explain Query > Plan", but this is too simple for what I'm looking for. As well as EXPLAIN QUERY PLAN there is also EXPLAIN (without the QUERY PLAN):

[sqlite] SQLite Profiler

2012-03-30 Thread TeDe
Hello, is anyone aware of a profiler for SQLite? I know the "Explain Query Plan", but this is too simple for what I'm looking for. We 've been using profilers for Sybase and MySQL, where you can see a lot more: index usage, number of page reads, returning rows and time - for the whole query and

Re: [sqlite] Sqlite profiler

2009-09-24 Thread George Bills
On 09/23/2009 11:16 PM, mcnamaragio wrote: > Hello, > > Would anyone be interested in sqlite profiler? If yes what features would > you expect from it? > > Thank you. > Yes, I would be interested. A high level breakdown of what SQLite is doing, and the time it's taking to do it would be

Re: [sqlite] Sqlite profiler

2009-09-24 Thread mcnamaragio
I am thinking about developing a profiler but I am at a very early stage. I have only ideas and nothing more yet. Before I start actual coding I would like to know if anyone is interested in it as it will motivate me if I know that people will benefit from the tool. I am not sure whether I will

Re: [sqlite] Sqlite profiler

2009-09-24 Thread Jim "Jed" Dodgen
how would your profiler differ from "explain"? http://sqlite.org/lang_explain.html On Wed, Sep 23, 2009 at 6:32 AM, Christian Schwarz wrote: >> Maybe, what is it? > > http://en.wikipedia.org/wiki/Profiling_(computer_programming) > > Cheers, Christian >

Re: [sqlite] Sqlite profiler

2009-09-23 Thread TeDe
mcnamaragio schrieb: > Hello, > > Would anyone be interested in sqlite profiler? If yes what features would > you expect from it? > > Thank you. > If you mean, that every sub-query and its execution-time is displayed: yes, definitely! I would even pay money for it. Features I would expect: -

Re: [sqlite] Sqlite profiler

2009-09-23 Thread RB Smissaert
] Sqlite profiler > Maybe, what is it? http://en.wikipedia.org/wiki/Profiling_(computer_programming) Cheers, Christian ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-us

Re: [sqlite] Sqlite profiler

2009-09-23 Thread Christian Schwarz
> Maybe, what is it? http://en.wikipedia.org/wiki/Profiling_(computer_programming) Cheers, Christian ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite profiler

2009-09-23 Thread RB Smissaert
Maybe, what is it? RBS -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of mcnamaragio Sent: 23 September 2009 14:16 To: sqlite-users@sqlite.org Subject: [sqlite] Sqlite profiler Hello, Would anyone be interested in sqlite

[sqlite] Sqlite profiler

2009-09-23 Thread mcnamaragio
Hello, Would anyone be interested in sqlite profiler? If yes what features would you expect from it? Thank you. -- View this message in context: http://www.nabble.com/Sqlite-profiler-tp25531129p25531129.html Sent from the SQLite mailing list archive at Nabble.com.

[sqlite] Sqlite profiler

2009-09-20 Thread giorgi giorgi
Hello, Is there anyone interested in sqlite profiler? If yes what features would you like to see? Thank you. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users