Reported By: Rob Rietow Reported On: 3/31/2004 For: Version 3.27 Build 1
# 1715Filters and SQL Evaluating Too Many Records with Mixed Optimized and Un-Optimized Conditions I have an sql process I was running in 3.24. It was running in the 0.01 or less time frame. In 3.27, now runs in 1.5+.
from reserv r
inner join namedet n on (n.confirmno = r.confirmno)
and r.eventno = 8861
and r.canceled = false
and r.waitlist = false
CommentsProblem also existed in 4.05 and was fixed there also.
ResolutionFixed Problem on 4/2/2004 in version 3.28 build 1