not surprisingly, the db2 approach is the only one that seems to
follow the "ideal" of the relational dbms. looks like you get to
provide to the engine information about your data, rather than
describing to the engine what steps it's supposed to take. hints
that directly influence query p
On Sep 22, 2008, at 11:18 AM, Jay A. Kreibich wrote:
> On Mon, Sep 22, 2008 at 10:07:54AM -0400, D. Richard Hipp scratched
> on the wall:
>> I am reluctant to add to SQLite the ability to explicitly specify the
>> index for a query. I agree with Alex Scotti that the who
On Sep 24, 2008, at 1:13 AM, Alex Scotti wrote:
>
> On Sep 23, 2008, at 2:35 PM, Jay A. Kreibich wrote:
>
>
>>
>> It doesn't "blatantly" anything. Indexes are outside of the
>> Relational Model and have nothing to do with it. They're
&g
On Sep 24, 2008, at 4:17 PM, Nicolas Williams wrote:
>
> But every commercial SQL RDBMS seems to have syntax for index control.
as "[EMAIL PROTECTED]" was kind enough to post on sept 21 to
this very mailing list, not all sql rdbms have taken this approach.
at least one, db2, chose the high
On Oct 29, 2008, at 4:59 AM, Julian Bui wrote:
> Hi everyone,
>
> First off, I'm a database and sqlite newbie. I'm inserting many many
> records and indexing over one of the double attributes. I am seeing
> my insert times slowly degrade as the database grows in size until
> it's unacceptable -
5 matches
Mail list logo