volume_up

A critical vulnerability was discovered in React Server Components (Next.js). Our systems remain protected but we advise to update packages to newest version. Learn More. 

volume_up

A critical vulnerability was discovered in React Server Components (Next.js). Our systems remain protected but we advise to update packages to newest version. Learn More. 
AI OnAI Offsmart_toy

Better way of getting all carts from two days back?

Bo Brinch
Bo Brinch
Vote:
expand_less 0 expand_more

I want to retrieve all carts from current and two days back. I retrieve the carts like this:

var cartFilter = new CartFilter()
{
ModifiedFrom = DateTime.UtcNow.AddDays(-2),
ModifiedTo = DateTime.UtcNow,
StartingRecord = 0,
RecordsToRetrieve = 20000
};

var carts = _serializableCartDB.FindCarts(cartFilter);

I could loop over this until I find the cart that I want, by changing StartingRecord for each iteration:

Loop 1: get 0-20000

Loop 2: get 20001...40000

Loop 3: get 40001...60000...found cart I want...now break.


Question is, whether there is an easier way to retrieve all carts in one go?

#197045
Sep 20, 2018 7:39
Quan Mai
Quan Mai
Vote:
expand_less 0 expand_more

No, you are doing it quite correctly - even though I think 20000 is still too much. Loading in batches is a good way to ensure you are not running into performance problems like timeout exception/out of memory exception 

#197046
Sep 20, 2018 8:22
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.