SELECT MQ_DocumentTranslations.DisplayName,
     MQ_Documents.Document_GUID,
     MQ_Documents.IncludeHeader,
     MQ_Documents.IncludeFooter,
     MQ_Documents.IncludeSignaturePage,
     MQ_Documents.IncludeTagLine,
     MQ_Documents.IncludePatientNameSection,
     MQ_Documents.IncludeCaregiverSection,
     MQ_Documents.IncludeFollowupSection,
     MQ_Documents.IncludeAdditionalNoteSection,
     MQ_Documents.IsForm,
     MQ_Documents.UseForDemo,
     mq_Documents.ForDemoOnly,
     mq_Documents.datalevel,
     mq_Documents.ref
   FROM MQ_Documents
     INNER JOIN MQ_DocumentTranslations ON (MQ_Documents.Document_GUID
= MQ_DocumentTranslations.Document_GUID)
   WHERE
     (MQ_DocumentTranslations.Language_GUID =
'{F3E5BA5E-87CE-428F-88B9-C705189C07C0}')
     AND (MQ_DocumentTranslations.Active=true)
     AND (MQ_Documents.Active=true)

---

 Comments

---

The query's source tables were encrypted, and the excessive read-ahead was exacerbated by this fact, thus resulting in the extreme variance in performance.

---

 Resolution

---

Fixed Problem on 2/20/2007 in version 1.01 build 1

---

 Products Affected

---

ElevateDB Additional Software and Utilities
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial