Loading...
Loading...
Search for a command to run...
Implement efficient pagination for large datasets
Implement efficient pagination for this query:
**Base Query:**
```sql
{{BASE_QUERY}}
```
**Table Size:** {{TABLE_SIZE}}
**Sort Requirements:** {{SORT_REQUIREMENTS}}
**Current Pagination Method:** {{CURRENT_METHOD}}
**Performance Issues:** {{PERFORMANCE_ISSUES}}
**Database System:** {{DATABASE_SYSTEM}}
Please provide:
1. Analysis of current pagination problems
2. Keyset/cursor pagination implementation
3. Offset pagination optimization
4. Hybrid approaches for different use cases
5. Total count optimization
6. Infinite scroll implementation
7. API response format
8. Caching paginated results
9. Performance benchmarks
10. Client-side implementation tipsOr press ⌘C to copy
Replace these placeholders with your own content before using the prompt.
{{BASE_QUERY}{{TABLE_SIZE}{{SORT_REQUIREMENTS}{{CURRENT_METHOD}{{PERFORMANCE_ISSUES}{{DATABASE_SYSTEM}Copy this prompt and paste it into your favorite AI tool