://sdm.lbl.gov/fastbit/
-Urspr?ngliche Nachricht-
Von: Eric Grange [mailto:zarglu at gmail.com]
Gesendet: Mittwoch, 04. M?rz 2015 08:24
An: General Discussion of SQLite Database
Betreff: Re: [sqlite] Multi-table index ersatz?
> Rowids will be faster than primary keys.
My primary keys are ROW
> Rowids will be faster than primary keys.
My primary keys are ROWIDs ("INTEGER PRIMARY KEY" actually)
None of the index was exploited for the order by, and the matched records
in table A are scattered in pages all over the database, so ordering them
in memory has a tendency to "replace" the whol
On 03/03/2015 06:10 PM, Eric Grange wrote:
> Hi,
>
> I have problem where I need a "multi-table index" ersatz, or maybe a better
> data structure :-)
>
> The problem is as follow:
>
> - Table A : some fields plus fields A1 & A2
> - Table B : some fields plus fields B1 & B2
>
> Both tables h
glu at gmail.com]
Gesendet: Dienstag, 03. M?rz 2015 12:10
An: General Discussion of SQLite Database
Betreff: [sqlite] Multi-table index ersatz?
Hi,
I have problem where I need a "multi-table index" ersatz, or maybe a better
data structure :-)
The problem is as follow:
- Table A
Eric Grange wrote:
> select ...some fields of A & B...
> from A join B on A.A2 = B.B2
> where A.A1 = ?1
> order by B.B1
> limit 100
>
> Without the limit, there can be tens of thousandths resulting rows,
Even with the limit, all the tens of thousands rows must be sorted.
> without the A1 conditio
Yes A2 & B2 are already indexed (individually and in composite indexes)
The problem is that this indexing is not selective enough when taken in
isolation.
Le 3 mars 2015 12:36, "Simon Davies" a ?crit
:
> On 3 March 2015 at 11:10, Eric Grange wrote:
> >
> > Hi,
> >
> > I have problem where I need
On 3 Mar 2015, at 11:10am, Eric Grange wrote:
> With indexes on A & B, the performance of the above is not very good, as
> indexing A1 is not enough, and indexing B1 is not enough either, so no
> query plan is satisfying.
The B1 index isn't going to be used. Here is your query:
select ...some
Hi,
I have problem where I need a "multi-table index" ersatz, or maybe a better
data structure :-)
The problem is as follow:
- Table A : some fields plus fields A1 & A2
- Table B : some fields plus fields B1 & B2
Both tables have several dozen millions of rows, and both are accessed
indep
On 3 March 2015 at 11:10, Eric Grange wrote:
>
> Hi,
>
> I have problem where I need a "multi-table index" ersatz, or maybe a better
> data structure :-)
>
> The problem is as follow:
>
>- Table A : some fields plus fields A1 & A2
>- Table B : some fields plus fields B1 & B2
>
> Both table
9 matches
Mail list logo