This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi, i was wondering why with a SimpleDb connection I can not do this: var query = new Query(typeof(MyData)){ QueryExpression = queryExpression, Order = Order.By(orderBy), Page = Page.Limit(1000)}; but I can return ALL of the records if I do not specify 'Page.Limit' It seems that Lightspeed will follow the 'next token' for more than 250 results only if I do not send in any limit. Is there any way for Lightspeed to allow a call like "context.MyData.Where(x => x.id > 0).Take(25000)" with SimpleDB? Thanks, -Joe Freeman |
|
|
Can you just confirm which build of LightSpeed you are using? We did make some changes in this area a little while back which look like they should have made this work -- I am pretty sure you already have these changes, in which case I will need to investigate further, but I just want to check. |
|
|
I am on the 5/19/2009 build 2.2.1113.11256 i guess it has been a while... I should get the latest build? Thanks, -Joe
|
|
|
Okay, that should include all the relevant changes: the only changes we've made to SimpleDB since 11256 then are some M/DB compatibility fixes, so I wouldn't bother updating yet. I will look into this issue and get back to you. |
|
|
I've committed a candidate fix for this and it will be in the 11 June nightly build, available from about 1430 GMT. Please let us know if you run into any issues. Also, apropos of your examples, I realise the numbers probably weren't meant to be realistic, but just to be clear, if you do a Take(25000) then this will incur 100 round-trips to Amazon, and these will occur synchronously when you start enumerating the query. I.e. we do not fetch subsequent 250-record blocks lazily on demand -- we fetch the entire "page", all 25000 records of it, up front. |
|
|
Thanks Ivan, This is exactly what we need. FYI: the numbers actually are realistic... This issue came up while creating a google Sitemap.xml dynamically: http://en.wikipedia.org/wiki/Sitemaps so, since sitemaps are limited to 50,000 records, we actually could want to do something like Take(50000), which would be 200 roundtrips to amazon. Thanks again, -joe |
|