AW: OT: Need some SQL advice

[Tiemo Hollmann TB]

Thank you Ruslan,
good to know looking into the right direction.
Tiemo

> -----Ursprüngliche Nachricht-----
> Von: valentina-bounces at lists.macserve.net [mailto:valentina-
> bounces at lists.macserve.net] Im Auftrag von Ruslan Zasukhin
> Gesendet: Montag, 29. November 2010 12:23
> An: valentina at lists.macserve.net
> Betreff: Re: OT: Need some SQL advice
> 
> On 11/29/10 1:18 PM, "Tiemo Hollmann TB" <toolbook at kestner.de> wrote:
> 
> > 2. How do you design "subsequent" queries to speed up the
> performance? If the
> > user first selects an option in search field 1 I get a number of
> matching
> > records.
> > If now the user selects an option from search field 2 to narrow the
> search I
> > would like to query only the resulting records from the first search
> instead
> > of goign onto the full db with both search criterias. Can I handle
> this just
> > in memory (if yes how?) and leave my db a read only file or would I
> have to
> > create some kind of resulting fields in my table and write back the
> resulting
> > records from first search?
> > If the user deselects one of the combined search criterias I have to
> query
> > again the full db.
> > Or are these completely unnessesary thoughts with 20000 records and I
> should
> > go with every query on the full db?
> 
> SQL way do not give you optinos to control this.
> 
> In API WAY (recommended only for LOCAL DBs)
> Yes you can manually use API way and Vset class
> To step by step produce result for the next field
> And to reuse sets from f1 and f2 ...
> 
> 
> > 3. For my field 7 with the OR options I would use the "IN" clause.
> right? Or
> > is there a more elegant/faster way?
> 
> right
> 
> --
> 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]
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina