Thanks for your answer Ms. Smith!
On 9/19/06, Christian Smith <[EMAIL PROTECTED]> wrote:
Cesar David Rodas Maldonado uttered:
> I meen, If SQLite has two index and very large Index (about 10.000.000each
> one) how do i merge it, I mean (index1 = index2 for every one and limit
it
> in thousand).
>
> Understand?
I guess not.
Are you trying to do an INNER JOIN merger on the two indexes? SQLite does
this by having a nested loop, with the equality test as the action of the
inner loop:
for each row in x {
for each row in y matching x.row {
# Do whatever for the inner join
}
}
If you're trying to do equivalent of a UNION select, then this is just a
standard merge sort using the two indexes as the sources.
http://en.wikipedia.org/wiki/Merge_sort
>
>
> On 9/15/06, Dennis Cote <[EMAIL PROTECTED]> wrote:
>>
>> Cesar David Rodas Maldonado wrote:
>> > If there a document of how SQLite Virtual Machine Works ( papers )? I
>> > would
>> > like do something similar with B-Tree, B+ Tree but i dont know how to
>> > merge
>> > a select with tow Index? Understand my question??
>> >
>> > Please answer me
>> >
>> see the links VDBE Tutorial and VDBE Opcodes near he bottom of the
>> documentation page http://www.sqlite.org/docs.html
>>
>> Dennis Cote
>>
>>
>>
>>
-----------------------------------------------------------------------------
>> To unsubscribe, send email to [EMAIL PROTECTED]
>>
>>
>>
-----------------------------------------------------------------------------
>>
>>
>
--
/"\
\ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
X - AGAINST MS ATTACHMENTS
/ \
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
