Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select records N to N + 10 with order by clause
Message
De
24/09/2002 11:04:13
 
 
À
24/09/2002 05:18:40
Information générale
Forum:
Oracle
Catégorie:
PL/SQL
Divers
Thread ID:
00703675
Message ID:
00703800
Vues:
15
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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform