|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.
Back to the top