Questions tagged [pagination]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
6
votes
1answer
473 views

SQL Server table query with pagination performance tuning, understand the current solution

as stated in the title i start a performance tuning of a table query with pagination generated by a legacy program that use Linq To SQL as ORM. I have found this resource in which is highly ...
0
votes
0answers
11 views

I want pagination in oracle stored procedure

I want pagination in oracle stored procedure in which I will give page start index, page size as input parameter and using offset for skip rows. My query for getting data is a string query of varchar2:...
0
votes
2answers
47 views

Limit and offset (pagination) for rows with related data (with joins)

I have tables Alpha and Beta. Beta belongs to Alpha. create table Alpha ( id int auto_increment primary key ); create table Beta ( id int auto_increment primary key, alphaId ...
1
vote
2answers
541 views

MySQL: Data pagination according data on another table

I have a database with the following structure Items table: itemID, itemName Ads table: AdsId, itemID I would like to make pagination on items table, 10 items in each page, but first I must retrieve ...