[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
|
Re: [eclipselink-users] Re portQuery vs ReadAllQuery
|
I updated the first post with separate sql.
/Daniel.
tch wrote:
>
> What's the SQL that's generated from each look like?
>
> ./tch
>
>
>
> On Mon, Nov 22, 2010 at 12:34 PM, Daniel Rickardsson
> <daniel.rickardsson@xxxxxxxxx> wrote:
>>
>> Hello!
>>
>> I have a problem using ReadAllQuery with its pagination functionality.
>> Let's say that we have 5000 entities in a db over a specific geographic
>> area.
>> And if I query with a spatial expression that covers that area and limits
>> the query (setFirstResult = 1, setMaxRows=3500) then a receive to few
>> posts.
>> I never get up to 3500 results?
>>
>> But if I do the same query as above with ReportQuery, but just gets the
>> id's
>> of the entities, then the query works fine?
>>
>> Why is there a difference between these implementations? I should work
>> the
>> same because ReportQuery is just a subclass from ReportAllQuery..
>> --
>> View this message in context:
>> http://old.nabble.com/ReportQuery-vs-ReadAllQuery-tp30280826p30280826.html
>> Sent from the EclipseLink - Users mailing list archive at Nabble.com.
>>
>> _______________________________________________
>> eclipselink-users mailing list
>> eclipselink-users@xxxxxxxxxxx
>> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>>
> _______________________________________________
> eclipselink-users mailing list
> eclipselink-users@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>
>
--
View this message in context: http://old.nabble.com/ReportQuery-vs-ReadAllQuery-tp30280826p30295972.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.
