[sqlite] Last time analyze was ran

On 11 Apr 2016, at 8:32pm, Jose I. Cabrera wrote: > Just resending, as I didn't see a post for this one. Thanks. I don't think anyone can think of a way to do it. Therefore no responses. You could have your software make a note and store it in the database but SQLite doesn't note it itself.

[sqlite] Final preparations for the release of System.Data.SQLite v1.0.100.0 have begun...

If you have any issues with the current code, please report them via this mailing list (and/or by creating a ticket on "https://system.data.sqlite.org/";) prior to Friday, April 15th. Thanks. -- Joe Mistachkin

[sqlite] Last time analyze was ran

Just resending, as I didn't see a post for this one. Thanks. On Monday, April 11, 2016 12:20 PM, Jose I. Cabrera wrote: Greetings! Is there a way to know when was the last time Analyze was ran on a database? My apologies if this was asked before, but I google a few searches to try to

[sqlite] Last time analyze was ran

Greetings! Is there a way to know when was the last time Analyze was ran on a database? My apologies if this was asked before, but I google a few searches to try to find the answer, but there were none that showed anything regarding the question. So, I thought to ask the gurus. Thanks. jos

[sqlite] Sqlite and we7 local time issue

Gunnar Roth wrote: > > The problem is that wec7 is missing the localtime function, but there > is replacement code for windows ce in sqlite , but no prototype. So > when i build i get still a linker error for localtime as localtime is > used before it is defined and that usage generates a int lo

[sqlite] Query optimizer not doing so well with my queries

Hi, I'm a big fan of SQLite, but I've been having some terrible speed problems when doing joins between subqueries. Strangely, if I join twice (first to the main table and then to its subquery), I can get the same answer in tenths of seconds and not minutes - or one thousand times faster. For ex

[sqlite] [shell][Feature Request] short form for SQLite3's shell's .dump command

I'm adding a smallish DB to version control (for unit testing purposes). The binary .db is 52 KB. The ascii .dump is 64 KB. The manually edited dump to take advantage of insert into t values (v1),(v2),(v3),...; is only 37 KB. The compressed sizes are much closer of course, since all the duplicated

[sqlite] Query optimizer not doing so well with my queries

Richard Warburton wrote: > For example, this takes minutes: CPU Time: user 263.759513 sys 2.237379 > SELECT s.Id, s.BookingId, s.At, s.DateIn, s.DateOut, s.RoomUID, > s.RatePlanUID FROM StayV s > WHERE NOT EXISTS (SELECT NULL FROM InvoiceItemV i WHERE i.PriceUID IS NULL > AND i.StayUID=s.UID); > >

[sqlite] Expecting syntax error on delete

The expression "a in ('abc','def')" will return either TRUE or FALSE so your condition devolves to "a in (TRUE, FALSE)" which is FALSE for all text values. -Urspr?ngliche Nachricht- Von: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.o