SQL request and speed ? II

[Thierry Nauze]

Le 25 août 05 à 23:02, Ruslan Zasukhin a écrit :

> On 8/25/05 8:20 PM, "Thierry Nauze" <ohmitou at wanadoo.fr> wrote:
>
>
>> Hello,
>>
>> I have two versions of my program : the first with a database
>> Valentina 2 and the other one with a database RealSQL.
>> The base contain the same data. The SQL requests  are the same and
>> their treatment also.
>>
>> Only to fill  a cursor (with 1 element taken in a table of 2000
>> records), with this request:
>>
>> " SELECT * FROM noms WHERE id>0 AND nom NOT IN (SELECT DISTINCT nom
>> FROM individus) " _
>>    +"AND nom NOT IN(SELECT DISTINCT nom FROM alias) ORDER BY nom "
>>
>> Valentina 2.05fc12:     9 seconds
>> RealSQL:                      0.13 seconds !
>>
>> It is an example among the others !
>>
>
> Well, SqlLite all resolve in RAM. So it can be fast until your  
> result fit
> RAM.
>
> Please send us your db and your query...
> We will test.
>
> I think we can "fix" problem just adding small analyze of result  
> size and
> usage of RAM tables for small results.

Hi Ruslan,

When I shall have finished the adaptation of my program, I shall  
write a project with the requests which put most problem and I shall  
send it to you.

Regards,

--
Thierry NAUZE        Saint-Denis de la Réunion