methodology can hope to
>> establish
>> > correct behaviour of the program.
>> >
>> > RB Smissaert wrote:
>> >> Poor comparison in this case.
>> >> Are you going to make a mathematical model when you got a little
>> stream
>> >> to
>> >>
viour of the program.
>>>
>>>RB Smissaert wrote:
>>>
>>>>Poor comparison in this case.
>>>>Are you going to make a mathematical model when you got a little stream
>>>>to
>>>>cross and you have a few available planks to do it?
&g
ote:
> >> Poor comparison in this case.
> >> Are you going to make a mathematical model when you got a little stream
> >> to
> >> cross and you have a few available planks to do it?
> >>
> >> RBS
> >>
> >>
> >>
Re: Re: Re: Re: Re: Re: How does SQLite choose
the
index?
We learn mathematics etc so that we can make numerical models which give
us design information. Imagine trying to build every combination of a
bridge to settle on a design!
Make a mathematical model and get it close to optimal at the fir
>>>I will see if I can put together a report that runs all possible types
>>> of
>>>queries (sequentially) and then see if I have left anything out that
>>> would
>>>cause problems.
>>>
>>>RBS
>>>
>>>
>>>-Ori
e: Re: Re: Re: How does SQLite choose the
index?
We learn mathematics etc so that we can make numerical models which give
us design information. Imagine trying to build every combination of a
bridge to settle on a design!
Make a mathematical model and get it close to optimal at the first at
Subject: Re: [sqlite] Re: Re: Re: Re: Re: Re: Re: How does SQLite choose the
index?
We learn mathematics etc so that we can make numerical models which give
us design information. Imagine trying to build every combination of a
bridge to settle on a design!
Make a mathematical model and get it close
-users@sqlite.org
Subject: Re: [sqlite] Re: Re: Re: Re: Re: Re: Re: How does SQLite choose the
index?
RB Smissaert wrote:
I think an application that
would produce all the needed indexes based on the table and all the
possible
queries would be helpful. Anybody done such an app?
_All_
2007 03:35
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Re: Re: Re: Re: Re: Re: Re: How does SQLite choose the
index?
RB Smissaert wrote:
> I think an application that
> would produce all the needed indexes based on the table and all the
possible
> queries would be helpful. Any
RB Smissaert wrote:
I think an application that
would produce all the needed indexes based on the table and all the possible
queries would be helpful. Anybody done such an app?
_All_ possible queries? Not practical for any significant number of
columns. N factorial gets big fast.
The inde
h that I am getting close now to having it all covered and
thanks again for all the assistance.
RBS
-Original Message-
From: Igor Tandetnik [mailto:[EMAIL PROTECTED]
Sent: 04 August 2007 23:45
To: SQLite
Subject: [sqlite] Re: Re: Re: Re: Re: Re: Re: How does SQLite choose the
in
RB Smissaert <[EMAIL PROTECTED]>
wrote:
But then if the base of the logarithm doesn't matter then
how is this equation going to help you?
m==N/logN
So, basically it comes down to some experimenting?
Well, it tells you that if m is much smaller than N (say, by two orders
of magnitude or more)
12 matches
Mail list logo
