We have had similar problems - one solution that works very well is to not contact the database to do big selects like this. We write such data into xml files onto the web server and make them accessible via a web service that is cached. This speeds up performance considerably, it sounds like a supplier list is not something that changes every minute so caching should not be a problem. You can then do whatever paging etc required within the xml and webservice.
-----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: 20 July 2011 18:15 To: u2-users@listserver.u2ug.org Subject: [U2] SELECT question, paginated select. I'm working on a screen in our webapp where we're using a dojo widjet to create a drop down with client names. The problem is that we have 1,000's of clients and when we do a SELECT on this many clients it takes a while. I know we can index the field but I was wondering if you can do smart selecting in UniVerse. For example if I wanted to use this query: SELECT CLIENT WITH @ID = "A]" SAMPLE 10 (returns 10 clients starting with the letter A). I want to paginate my drop down so the first query has the above data. The problem I'm facing is that I don't know how to get the NEXT 10 clients? Is there a way to do this? For example if I wanted to return the next 10 CLIENTS, without including any of the first 10. Chris _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ----- No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1390 / Virus Database: 1518/3776 - Release Date: 07/20/11 _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
