Re: how to display partial results from a query (effectively)

Thanks Billy,

Yes, I understand the stateless web, however when I look at all the sites where you search for something, and the results displays over a lot of pages - Take google f.ex. (yes, I know, Linux clusters, blah blah...)

• all these sites are fast, and the application I'm working on is SLOOOOW. So what you're saying the only thing I can do is to tune the query to be as effective as possible, and that's it? Does all the search sites rerun the query in full every time you hit "next/previous"?

btw. in this case the queries are within EJB code, passed through thin JDBC to oracle. The results are displayed through JSP (weblogic server).

Billy Verreynne <vslabs_at_onwe.co.za> wrote in message news:<aplg1j$bbb$1_at_ctb-nnrp2.saix.net>... [cut]
> However.. this is not possible via a normal web interface. A cursor requires
> a session to be kept alive and open. In other words, it needs state.
>
> A web server by default is stateless. So to use cursors via a web server,
> you need to make those connection into sessions. Which is another rusty,
> half-empty, slightly warm, beer can.
Received on Tue Oct 29 2002 - 12:54:55 CST