OT: Need some SQL advice

[Ruslan Zasukhin]

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]