[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-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


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

2011-04-10 Thread mcnamaragio

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