You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
constresults=awaitc.env.DB.prepare(`SELECT * FROM participants_d3 ${whereClause}`).all();
While the table is small enough now, this approach may lead to performance issues and excessive memory usage as the number of participants grows. We should implement pagination to ensure the application remains scalable.
The text was updated successfully, but these errors were encountered:
The current participant query implementation fetches all participants without pagination:
egytech-fyi-api/src/routes/participants.ts
Line 36 in 704e8df
While the table is small enough now, this approach may lead to performance issues and excessive memory usage as the number of participants grows. We should implement pagination to ensure the application remains scalable.
The text was updated successfully, but these errors were encountered: