Hi,

My last email wasn't very clear, but I eventually got the order by clause to work.

The problem currently is that any proposed solution is too slow.

My aim is to "page" records so that the user can see 10 records per page. The current test table has 50,000 records and the user can elect to view, for example, records 49,991 to 50,000 or records 1 to 10 or anything in between.

The user can also sort the data by any of the displayed fields.

All the solutions I've tried are fine for small tables. Each record contains a unique ID which is populated by a sequence.

My proposed solution was to get a list of 10 record IDs for the selected page and then construct a query from that list to query the database for the rest of the data.

However, even just selecting 10 records gets too slow as you proceed to records 49,991 to 50,000.

Does anyone have a quick way of querying a table for this data ?

Best.

Matt.