ok i will try
On 12/9/2010 9:33 PM, Richard Hipp wrote:
> On Thu, Dec 9, 2010 at 11:27 AM, Vander Clock Stephane<
> svandercl...@yahoo.fr> wrote:
>
>> no one have an idea how to do such query ??
>>
> You can try building with SQLITE_ENABLE_STAT2 and then running ANALYZE. Or,
> the query you show
> I can't solve your problem but I have observations. I don't see how any SGDB
> (or RDBS as we call them) could do this quickly without lots of indexes.
>
but they do :( Firebird for exemple ...
> Your long SELECT command is something I would probably do in my programming
> language instead
> If you have another situation,
> wit same amount of data,
> which returns immedialty,
> than either situation is not the same,
> or you are making an error.
>
same situation (same amount of data) but on other SGBD like Firebird.
the result
return imediatly. on sqlite3 it's take hours :(
> may
On Thu, Dec 9, 2010 at 11:27 AM, Vander Clock Stephane <
svandercl...@yahoo.fr> wrote:
> no one have an idea how to do such query ??
>
You can try building with SQLITE_ENABLE_STAT2 and then running ANALYZE. Or,
the query you show is ideally suited for the R-Tree module.
>
> thanks
> stéphane
On 9 Dec 2010, at 4:27pm, Vander Clock Stephane wrote:
> no one have an idea how to do such query ??
I can't solve your problem but I have observations. I don't see how any SGDB
(or RDBS as we call them) could do this quickly without lots of indexes.
>x3_y2>=<#randomnumber34> and
>x
On 09-12-10 17:27, Vander Clock Stephane wrote:
> no one have an idea how to do such query ??
>
> thanks
> stéphane
>
> On 12/8/2010 7:56 PM, Vander Clock Stephane wrote:
>> Hello,
>>
>> on the table :
>>
>> CREATE TABLE HASH(
>> .
>> x5_y5>=<#randomnumber73> and
>> x5_y5<=<#rando
no one have an idea how to do such query ??
thanks
stéphane
On 12/8/2010 7:56 PM, Vander Clock Stephane wrote:
> Hello,
>
> on the table :
>
> CREATE TABLE HASH(
> ID INTEGER PRIMARY KEY ASC,
> x1_y1 INTEGER,
> x1_y2 INTEGER,
> x1_y3 INTEGER,
> x1_y4 INTEGER,
> x1_y5 INTEG
7 matches
Mail list logo