On Sat, 10 Sep 2005, Ned Batchelder wrote:
> Rather than overload an existing SQL keyword, would it be possible to
> provide pragmas to control the optimizer? Assigning meanings to particular
> combinations of SQL queries won't scale as the number of optimizer controls
> grows.
I would like to
On Sat, 2005-09-10 at 21:37 -0700, Gerry Snyder wrote:
> 2) The behavior is as expected,
> and there are good reasons why loading 3 then 2 works but loading 2
> then
> 3 doesn't, and such behavior can be counted on in future releases of
> version 3.
Two is correct. You have to load version 3
Hello Linas,
It is not SQLite's problem. It is problem of ADOdb.
Sunday, September 11, 2005, 8:14:44 PM, you wrote:
LV> Hello,
LV> I have a problem using SQLite 3 with ADOdb - SELECT query returns 0 results.
LV> Everything you might want to know is here:
LV>
I believe the following quick start example leaves
the program open to a potential memory leak when
the call to sqlite3_exec is not equal to SQLITE_OK
because zErrMsg is not explicitly freed.
Reference the example:
http://www.sqlite.org/quickstart.html
The error can be reproduced by
Don't?
Use a :memory: table or a ramdisk. periodically (or at commit time?)
save a copy of the database elsewhere- perhaps in another form- perhaps
in a form that's less pleasant to query quickly.
On Wed, 2005-09-07 at 14:48 +0800, SH L wrote:
> I found sqlite will update some fixed places
>
On Sat, 2005-09-10 at 19:25 -0400, D. Richard Hipp wrote:
> Beginning with SQLite 3.2.3, the query optimizer has had
> the ability to reorder tables in the FROM clause if it thinks
> that doing so will make the query run faster. This has caused
> a few problems for some folks. To ameliorate
On Sat, 2005-09-10 at 21:38 -0400, Ned Batchelder wrote:
> Rather than overload an existing SQL keyword, would it be possible to
> provide pragmas to control the optimizer? Assigning meanings to particular
> combinations of SQL queries won't scale as the number of optimizer controls
> grows.
I
7 matches
Mail list logo
