--- "Mrs. Brisby" <[EMAIL PROTECTED]> wrote:
> That all said, it seems like this problem is already solved- SQLite does
> the right thing after ANALYZE is called. Perhaps it wouldn't be too
> difficult to update the statistics that ANALYZE collects in after
> COMMIT, or perhaps after a COMMIT that
On Sep 4, 2005, at 5:53 AM, Igor Tandetnik wrote:
Christopher R. Palmer wrote:
Unfortunately, that's not the case. The code that was being used
when I created ticket 1272 was very simple. In the main thread, I
opened a handle for each thread. Each thread then worked
independently using onl
> People who visit a website that looks like junk _NEVER_ say "oh my web
> browser is being a piece of shit."
...unless they're the same people who designed it ;)
On Mon, 2005-09-12 at 07:15 -0400, Ned Batchelder wrote:
> I'm not sure if we agree or disagree. You say:
>
> > I don't think the number of optimizer controls should grow.
> > It should be kept as close to zero as possible.
>
> But then you say:
>
> > If [the optimizer] can make a mistake, I w
> and so it does. Gracias. ;-)
>
> Now I am off happily experimenting with applying other functions to
> ORDER BY before ordering them.
Thanks Derrell.
You've used your super powered intellect well today! ;)
---
The Castles of Dereth Calendar: a tour of the art and architecture of
Asheron's
On Sep 12, 2005, at 8:54 AM, [EMAIL PROTECTED] wrote:
Jay Sprenkle <[EMAIL PROTECTED]> writes:
If you just want 10 records with the highest modified or created time
I
think this will do it:
select *
from tbl
order by max(created_on,modified_on) desc
limit 10
except that if modified_on is
>
>
> > If you just want 10 records with the highest modified or created time I
> > think this will do it:
> >
> > select *
> > from tbl
> > order by max(created_on,modified_on) desc
>
> I didn't realize MAX could be used in ORDER BY.
>
> However, the above does not work. It seems to overlook a
Jay Sprenkle <[EMAIL PROTECTED]> writes:
> If you just want 10 records with the highest modified or created time I
> think this will do it:
>
> select *
> from tbl
> order by max(created_on,modified_on) desc
> limit 10
except that if modified_on is null, you won't get that record. This variati
On Sep 12, 2005, at 8:43 AM, Jay Sprenkle wrote:
On 9/12/05, Puneet Kishor <[EMAIL PROTECTED]> wrote:
my table is
name (VARCHAR), created_on (DATETIME DEFAULT CURRENT_TIMESTAMP),
modified_on (DATETIME)
When a new record is created, it gets a value in the created_on col,
which is then not ch
On 9/12/05, Puneet Kishor <[EMAIL PROTECTED]> wrote:
>
> my table is
>
> name (VARCHAR), created_on (DATETIME DEFAULT CURRENT_TIMESTAMP),
> modified_on (DATETIME)
>
> When a new record is created, it gets a value in the created_on col,
> which is then not changed subsequently, but the modified_o
my table is
name (VARCHAR), created_on (DATETIME DEFAULT CURRENT_TIMESTAMP),
modified_on (DATETIME)
When a new record is created, it gets a value in the created_on col,
which is then not changed subsequently, but the modified_on col is
empty. Whenever the record is updated, the modified_on c
Jay Siegel wrote:
For example, using google I accidentally found
http://www.sqlite.org/php2004/slides-all.html which is
Yeah, I found this also accidentally while browsing the older news
section(because I use 2.8.16), and found it immediately very
interesting. It deserves to be on a better s
I'm still pretty new to sqlite but have written a few
test programs over the last month and gotten everthing
working well. For small-to-medium sized tables, the
performance is great - this is a wonderful tool to use
for large and complex application files, especially
ones where there is variable s
when a sqlite3_Step call fails, say on a unique key violation of an
INSERT statement,
the returned error code is SQLITE_ERROR, which is documented.
calling sqlite3_errcode at this point, however, also gives the same
error, which is not.
the correct error, which is SQLITE_CONSTRAINT, is only retu
I'm not sure if we agree or disagree. You say:
> I don't think the number of optimizer controls should grow.
> It should be kept as close to zero as possible.
But then you say:
> If [the optimizer] can make a mistake, I want a simple
> and _unobtrusive_ way to correct _just_that_mistake_ for
>
Try 'make doc' :))
Fanda
--- Forwarded message ---
From: "Firman Wandayandi" <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org, [EMAIL PROTECTED]
Cc:
Subject: Re: [sqlite] SQLITE Documentation
Date: Mon, 12 Sep 2005 10:08:36 +0200
On 9/12/05, ShepherdHill DB Subscriptions
<[EMAIL PROTECTED
On 9/12/05, ShepherdHill DB Subscriptions
<[EMAIL PROTECTED]> wrote:
> Hi,
>
> Can anyone point me to how I can get the full download of the SQLITE
> documentation in html? I will like to compile and maintain the CHM
> version of the document so that users can reference the documentation
> offline
Hi,
Can anyone point me to how I can get the full download of the SQLITE
documentation in html? I will like to compile and maintain the CHM
version of the document so that users can reference the documentation
offline.
Best regards.
Chris.
18 matches
Mail list logo