Database indices and pagination #40

New Issue

yequari · 2025-08-17T16:18:19Z

yequari commented

2025-08-17 16:18:19 +00:00

Need to make the following improvements to the DB code:

Indices:
- Create an index on guestbooks table based on user id
- Create an index on guestbook comments based on guestbook id
Pagination
- Add methods in models package to grab a list of each model based on page parameters so we can grab only 10 or 15 entries at a time. See this link for info.
- Use these methods anywhere that we are grabbing a large list of models for display, like on the comment dashboard or in the admin panel

Need to make the following improvements to the DB code: - Indices: - Create an index on guestbooks table based on user id - Create an index on guestbook comments based on guestbook id - Pagination - Add methods in models package to grab a list of each model based on page parameters so we can grab only 10 or 15 entries at a time. See [this link](https://use-the-index-luke.com/no-offset) for info. - Use these methods anywhere that we are grabbing a large list of models for display, like on the comment dashboard or in the admin panel

yequari referenced this issue

2025-08-17 16:18:41 +00:00

General UI Improvements #39

yequari added this to the Guestbook 1.0 project 2025-08-17 16:18:49 +00:00

Sign in to join this conversation.

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: 32bitcafe/guestbook#40