SharePoint Rest API taking around 13 seconds to fetch data from List based on some filter conditions. This is making the app slow for the users and they are complaining. Is there a way to make the REST call a bit faster ?
Added the code which calls the REST end point.
function getTasks() {
return $http({
method: 'Get',
url: _spPageContextInfo.webServerRelativeUrl + "/_api/SP.AppContextSite(@target)/web/lists/getByTitle('TasksList')/items?$select=*,ProjectTitle/Title,ProjectTitle/Id,ResponsiblePersons/Id,ResponsiblePersons/Title,Attachments,AttachmentFiles,TaskRequestor/Id,TaskRequestor/Title&$expand=ProjectTitle,ResponsiblePersons,AttachmentFiles,TaskRequestor&$top=9999&@target='" + spContext.hostWebUrl + "'",
headers: {
'Accept': 'application/json;odata=verbose',
}
});
}
async: true
or mention only the required columns instead of "*" in select section – Ashik Paul Jun 25 '18 at 8:29