Reported By: Rob Rietow Reported On: 3/31/2004 For: Version 4.05 Build 1
# 1646Filters 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+.
select n.lname,n.fname,n.weight
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 4.06 build 1