[sqlite] Sqlite profiler
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-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite profiler
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 be able to capture all the information but I hope it will be a useful tool. Thank you for sharing your opinion :) TeDe wrote: > > 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: > - execution-time of every sub-query > - records affected by every where-clause > - indexes used > - maybe a small graphical interface? > - tabbed interface to compare different versions of a query during > optimization > > What are your plans? > > Best Regards, > > Thomas > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/Sqlite-profiler-tp25531129p25586644.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite database corrupted
Thanks. I have found that the select statement was issued inside a transaction. Could this cause sqlite to make changes to the database? I also observed that if I mark the database as readonly and issue a select statement inside a transaction (what the application was doing) I get "attempt to write a readonly database" error so it looks like sqlite is trying to have write access to the database even thought it is not needed. Could this have caused database corruption? Simon Slavin-3 wrote: > > On 9 Apr 2011, at 02:47 PM, giorgi giorgi wrote: > >> The application is only issuing select statements (no >> insert/update/delete >> or vacuum) so I cannot understand what could have caused database >> corruption. > > Almost definitely a problem with your hardware, or possibly an > operating-system glitch. I'm not going to pretend that SQLite is bug-free > but if you're not executing write commands it has no reason to write > anything at all. > > Simon > -- > Sent while away from my computer. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://old.nabble.com/Sqlite-database-corrupted-tp31359173p31364155.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users