Re: Question and suggestion regarding rownum

"ketan Parekh" <ketanparekh_at_sbcglobal.net> wrote in message news:<dOZsb.55$VX4.0_at_newssvr13.news.prodigy.com>...
> Lakshmi - but again with Order by clause and Group all this goes for a toss
> For a more clear picture imagine you doa search on google.com and u have 2
> million hits and it displayes on 10
> but before it shows u page,2,3,4,5 next - u click on page 4 directly which
> should display from 31 to 40 - this is what
> I have to accomplish.

I hate to say it, but google doesn't always work correctly. It lacks consistency, you wind up seeing things like the count not matching how many things are found, so displaying 31 to 40 may show the same things as 41 to 50, and the last page may have nothing at all. Sometimes it doesn't find things that it finds at other times. Sometimes things will come and go as you page forward and backward. That's not even counting new things coming into the possible result set during the session. Rather than reinventing the database wheel, they've given transaction processing a flat tire. But that's ok, it's just usenet, right?

500K table isn't so big. I routinely use a proprietary generic QBF to peruse several million row tables - it may hourglass a couple minutes for a non-key inquiry when the system is loaded.

Maybe you can use an autonomous transaction: get the first few pages quickly, while in the background the full set is being generated.

>
> "Lakshmi Jagarlapudi" <jlnarayana_at_comcast.net> wrote in message
> news:UgSsb.143292$ao4.458324_at_attbi_s51...
> > Maybe u can do something at the frontend level, but i think this sql
> should
> > work...
> >
> > select * from -- wrapper query.
> > (
> > select rownum mynum,empno,sal from emp -- actual query
> > )
> > where mynum between 45 and 55
> >
> > let me know if this is what u want.
> >
> >
> > <ketansweta_at_sbcglobal.net> wrote in message
> > news:THFsb.30024$FD7.22223_at_newssvr27.news.prodigy.com...
> > > Hi! Folks
> > >
> > > I am sure many of you have come across this problem which I am facing
> and
> > > hope to have some suggestions.
> > > We have an web application with tones of where clauses and group by but
> > > eventually the result set could be any where
> > > from 1 to 10000. Now the web page would display only 1 to 10 items after
> > > which if you would click on next it would show
> > > from 11 to 20 - till here it is some what do able - the problem lies
> when
> > > the user click on directly 45th page which should show records
> > > from 2000 onwards. I was thinking of using the rownum function ..
> remember
> > > this is a select from a 500K table - .
> > >
> > > Any folks who have a better idea or suggestion would be great ful.
> > >
> > > Thanks
> > > Ketan
> > >
> > >
> >
> >

jg

--
@home.com is bogus.
http://www.usatoday.com/life/television/news/2003-11-18-family-guy_x.htm