View Incident Report

Minor

Reported By: Rob Rietow
Reported On: 3/31/2004
For: Version 4.05 Build 1

# 1646 Filters 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

Comments

Problem also existed in 4.05 and was fixed there also.

Resolution

Fixed Problem on 4/2/2004 in version 4.06 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap