I would like to build a custom search page (using MVC/Razor) that uses the .NET SDK to search for records.
I have a basic template that works, but the query is much slower than the Service API (in the Web Drawer). Are there any helper methods, etc. in the SDK that can assist in making a more efficient/faster query:
It would be something like:
MainTrimObjectSearch records = new MainTrimObjectSearch(database, BaseObjectTypes.Record);
records.SetSearchString("uri:123456"); //Search criteria supplied by search form
var results = from r in records
This performs slow when querying 100s/1000s of records.