hi, take a look at setStartIndex and setEndIndex. You can implement paging with this for your next/prev buttons.
roger janssen -----Original Message----- From: Theo Niemeijer [mailto:[EMAIL PROTECTED] Sent: vrijdag 21 maart 2003 11:08 To: OJB Users List Subject: Webapp google queries: What is a good way to present multiple web pages with query results ? Maybe someone has a suggestion for me: The problem I am facing is that a user can have a very long list of results, and that list of items is presented in multiple pages of HTML (like Google :->) Let's assume that a query will have 10.000 resultitems, and I display 20 items per HTML page with a Next and a Previous button. - When I use a QueryIterator and for each next page just iterate 20 items further I assume that it will tie the database connection up for quite some time, and I can not even be sure that the user will ask for the next page of results ! - When I just get all the items in a large collection it will cost me a lot of "materialisation" time and a lot of memory. - When I only ask for the object identities and then get the pages by making a query for 20 identies in a kind of "select ... where id's in [....]" then the user would have to wait for that query, but it may be mcuh faster than the original query. - When I just re-submit the query for each page, and iterate to the correct 20 items then the user would have to wait for the query each time, but it may actually be fast because only 20 items would be "materialised". Anyone having experience with this problem and wanting to share best practices ? Regards, Theo Niemeijer --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] ************************************************************************* The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed.You should not copy, disclose or distribute this communication without the authority of iBanx bv. iBanx bv is neither liable for the proper and complete transmission of the information has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
