K2 smartobject takes too long to return data 30 seconds or so
Noticed This issue only on smart objects containing fields of type File.
However Running SQL query returns the data in just 2 seconds.
I have less than 5 records in the Database, why is the smartobject taking too long to execute?
we are using K2 Five
If you have the ability to, consider creating a SmartObject list method that does not return the file by default, then make a second request to retrieve the file when a user actually clicks on it based on the id of the row that was chosen
If you are returning the files as part of a list method then you're shipping the entire file contents back for each row.