Trouble reading from Object Store in CMS 5 R2 SP1

Vote:
 

Hello,

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:

[Serializable, XmlInclude(typeof(InterestDO))]
    public class InterestDO : IItem
    {
        private object id;
        private string name;
        private DateTime date;
        [Indexed(true)]
        private string market;
        private string club;
        [Indexed(true)]
        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();

query.OfType<InterestDO>();
query.Add(Expression.Equal("market", market));


return session.ExecuteQueryObject<InterestDO>(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.

#60839
Aug 28, 2012 12:09
Vote:
 

Im having more or less the same problem. 

#64785
Jan 10, 2013 9:59
This thread is locked and should be used for reference only. Please use the Episerver CMS 7 and earlier versions forum to open new discussions.