Hello,
The CAML Query below performs extremly slowly.
As a result the report takes upto 5 seconds to render after deployment to Sharepoint.
Can you see any areas for improvement in our query?
I can send the report RDL as attachment if desired!
<?
<
xml version="1.0" encoding="utf-8"?>root xmlns="http://enesyssoftware.com/schemas">
<queryName />
<description />
<list title="Sessions" relativeSiteUrl="http://dlamweb:36992/EducationTraining/" tableName="Sessions">
<fields>PickerDescription,ID,Total_x0020_Allowed_x0020_Studen,Seats_x0020_Remaining,Currently_x0020_Enrolled_x0020_S,Class,EventDate</fields>
<query>
<OrderBy>
<FieldRef Name="Class" />
</OrderBy>
</query>
</list>
<list title="Enrollments" relativeSiteUrl="http://dlamweb:36992/EducationTraining/" tableName="Enrollments">
<fields>Student,UCLAID,Confirmation_x0020_Number,Attend_x003f_,Session,SessionTitle</fields>
<query />
</list>
INNER JOIN Sessions ON Enrollments.SessionID = Sessions.ID
WHERE Enrollments.SessionID = @SessionID!
<sqlQuery tableName="SelectedSessionRoster"><![CDATA[SELECT Enrollments.Student,Enrollments.UCLAID,Enrollments.Confirmation_x0020_Number,Enrollments.Attend_x003f_,Enrollments.SessionTitle,Sessions.Currently_x0020_Enrolled_x0020_S,Sessions.Total_x0020_Allowed_x0020_Studen,Sessions.ID, Sessions.EventDate FROM Enrollments ]]></sqlQuery>
</
<resultSet>SelectedSessionRoster</resultSet>root>