SQL request and speed ? II

[Ruslan Zasukhin]

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.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]