While the current posts are focused on queries I was wondering if any member has done any testing as to the effect of the order of multiple rules (and/or) on speed? As example searching a customer form for male/female ( likely 50/50) and age over 100 (likely 1 in 1000+). Does the engine locate half the records then check all these for age (many thousands) or if age placed first (may be 100 persons), only a few records to check for male/female.
Will experiment if no one tried this out. Just need time to build a large file to push BD to limits ( 100,000+ records should show up any effect).
Just crossed my mind that we should check this out incase there was a speed issue. I believe Sql databases often use query optimisation but the circumstances are a bit different (no table joins for one) but with no help from BD the only way seems to test it ourselves.