[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
|
Re: [eclipselink-users] Oracle: Anyway to disable FIRST_ROWS hint on paginated queries?
|
And I'll answer my own question again. Looks like only the page size is being brought back, I'm just ignorant of how setFirstResults and setMaxResults work on the driver level. Are all results brought across the wire, and then just the rows in the windows returned? I'm worried about memory implications making this a global change....
./tch
On Thu, Jun 16, 2011 at 4:17 PM, Tim Hollosy
<hollosyt@xxxxxxxxx> wrote:
I added the hint, now I don't see the rownum things at all in my paging queries. What's actually happening here, would all rows be brought back into memory or is JDBC filtering them out?
I suspect I have some bad stats somewhere that are causing the CBO to go nuts with the first_rows on, and I just need to figure out which one and tweak it. That would be preferable to me than making such a large change globally in our app, unless of course I could tell Eclipselink to use rownum filtering, just without the hint....
./tch
On Thu, Jun 16, 2011 at 4:07 PM, Tim Hollosy
<hollosyt@xxxxxxxxx> wrote:
Won't that not use rownum filtering for pagination though, then how would it paginate?
./tch
On Thu, Jun 16, 2011 at 3:52 PM, Tom Ware
<tom.ware@xxxxxxxxxx> wrote:
Hi Tim,
Try using a session customizer and calling:
((DatabasePlatform)session.getDatasourcePlatform()).setShouldUseRownumFiltering(false)
-Tom
Tim Hollosy wrote:
We've run into a situation where the FIRST_ROWS hint is causing major pain, selecting against a view. Worked fine on our 10g database, production is 9i though and it's just dying on 9i, any clue on how to tell eclipselink to leave the hint out? When I leave it out, the query runs fine. I saw a post from 2009 that said it wasn't possible to disable it without modifying EL source.
As an alternative, any oracle wizards now how I might tell Oracle to ignore that hint?
Thanks,
Tim
_______________________________________________
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
