Im trying to extract alot of information (~31k items) from the ObjectStore but it seems it is really slow, and with that many rows the request times out after a couple of hours.
The item that is stored:
public class InterestDO : IItem
private object id;
private string name;
private DateTime date;
private string market;
private string club;
private string clubId;
private bool isCenter;
private string customerMail;
private string customerMessage;
private string customerName;
private string customerPhone;
How the Items are being retrieved:
session = Context.Repository.CreateSession();
Query query = new Query();
This is the query that is being run most of the time:
SELECT [pkID],[fkSchemaId],[Name],[ItemData] FROM [MyDatabase].[dbo].[tblItem]
Is there some way to extract the items directly from the Database or perhaps do some further limiting to the query? I've tried to limit the query with Take(), but without any luck. When i run the query above directly in the database it returns immediately so it has to be the deserialization thats the problem?
I've also tried to find some information about the Object Store but it seems replaced by Dynamic Data Store in later versions so if anyone knows if some documentation exists it would be really helpful.
Im having more or less the same problem.