Re: Find Next row - Performance questions

Quoting John LeBrun... } } The largest performance problem occurs when executing a } logical next/prev record request. (To explain: a logical next record, } given a key of N columns and a value, find the next record in key } order) I currently have an implementation that is flexible enough to } return the correct request for any table or key. I am looking for } comments and suggestions on ways to improve performance. } [ lots of statements and examples ommited to conserve band-width ] I don't know why there is a problem. If you create an index on say... (lname, fname, custno) and then declare the following cursor: DECLARE cust_curs SCROLL CURSOR FOR SELECT * FROM customers ORDER BY lname, fname, custno it will do exactly what you need it to do when you open it and start fetching. Are you new to Informix-4GL? If so, Informix's book 4GL By Example is a great book to learn from. You also might want to pick up a copy of "db4glgen" my public domain 4GL screen code generator. Good luck with your project! DAS -- David Snyder @ Snide Computer Services - Folcroft, PA Current Release is db4glgen-3.9 UUCP: ..!uunet!das13!dave INTERNET: dave.snyder@snide.com