sql command help

[Ruslan Zasukhin]

On 21/10/07 9:10 PM, "Trausti Thor Johannsson" <tj at quarksbar.net> wrote:

Hi Trausti.

> No, i do not know if mother / father is male or female, adoptions and
> stuff like that, complicated family pattern :)
> 
> It just can take quite some time to draw family trees of like 15
> generations.

Well try to use SQL Binaidng:

 query = "select * from person where ( (father=) or (mother=?) )"

 
See examples for details.

This step should compile query ONCE and reuse it for all other calls.
I can expect about 20 times speedup


-- 
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]