Speeding up Searches and Filters
|
Previous Top Next |
FilterOptions := [foCaseInsensitive];
|
Filter := 'State = ' + QuotedStr('CA');
|
· | an index speeds up (Name LIKE 'Jo%')
|
· | but an index doesn't speed up (Name LIKE '%Jo%') or (Name LIKE '_all')
|
· | Conditions joined by the OR operator: (State = 'CA') OR (State = 'NY')
|
· | Not Equal operator: (State <> 'CA')
|
· | IN: (Color IN ('red','blue'))
|
· | Condition with expression: (FirstName+LastName = 'Mark Brown')
|