| Subject | Best way to choose ALL or one item |
|---|---|
| Author | ra8009 |
| Post date | 2004-12-28T21:06:48Z |
My user wants to select a specific category or ALL categories. They
may have 100,000 to 200,000 records and speed will be important as the
user may run this hundreds of times per day.
Is the best way to hanldle this (I'm using IB Objects) to:
a) Build the SQL statement dynamically with the "where" clause or
without as needed
b) Use "Between" with two paramters. When one category is needed I
make them the same, when ALL are needed I set them to high and low
values above and below the range.
c) some other method
may have 100,000 to 200,000 records and speed will be important as the
user may run this hundreds of times per day.
Is the best way to hanldle this (I'm using IB Objects) to:
a) Build the SQL statement dynamically with the "where" clause or
without as needed
b) Use "Between" with two paramters. When one category is needed I
make them the same, when ALL are needed I set them to high and low
values above and below the range.
c) some other method