Re: [sqlite] Newbie question

I'm relatively newbie too, but just curious, is it anything to do with (select id from tbl2 where name="Joe") not being guarenteed to return a scaler? Ie only a single value? -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf

Re: [sqlite] Terrible performance for one of our tables

Out of interest why must it completely READ each entire row? Is it because '*' has been used? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of D. Richard Hipp Sent: 19 November 2008 12:05 To: General Discussion of SQLite Database Subject: Re: [sqlite]

[sqlite] Profiling

I am registering a trace function and a profile function and both aoppear to be getting correctly called back and the text looks in order. How ever the elapsed time in the profile always shows zero. Does any one have a guess at what I may have left out? Regards, Andrew

Re: [sqlite] Logging

base Subject: Re: [sqlite] Logging -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hardy, Andrew wrote: > What's the most efficient way of getting a log file of the db activity > on your sql db over a time period. Can you get timings against these > acrtivities? You have to write c

[sqlite] Logging

What's the most efficient way of getting a log file of the db activity on your sql db over a time period. Can you get timings against these acrtivities? Regards, Andrew ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Entity Relationship Diagram Tool for SQLite

Not sure if this is what David is getting at, iro specifically saying sqlite, but I'd be interested in something that generates a schema diagram from an existing sqlite db file. Or are there tools that can do this from the text of a dump, if the sql is standard enough? Andrew -Original

Re: [sqlite] Manifest Typing performance impact?

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Cote Sent: 27 August 2008 15:45 To: General Discussion of SQLite Database Subject: Re: [sqlite] Manifest Typing performance impact? Hardy, Andrew wrote: > > Is there a performance hit assosiated with manifest typing? >

[sqlite] Manifest Typing performance impact?

Is there a performance hit assosiated with manifest typing? Is it right that although info on the sqlite site suggests there is an avilable mode that supports strict typring, this is not infact the case? If there is a performance hit, what are the best ways to minimise this? And is there any

[sqlite] Manifest Typing performance impact?

Is there a performance hit assosiated with manifest typing? Is it right that although info on the sqlite site suggests there is an avilable mode that supports strict typring, this is not infact the case? If there is a performance hit, what are the best ways to minimise this? And is there any