Open Dark-Explorer opened 6 days ago
For pagination, this issue is currently using LIMIT and OFFSET to query first 200 records (equivalent to 20 pages of default 10 results per page). It allows user to choose 'Load more' to get next 200 records (which means we have to query the entire table again).
Another approach for pagination is partitioning the table with timestamp type column (start_time in Trips) and add WHERE clause with time condition to reduce the cost of running query.
This method requires billing information so it can't be implemented now.
Main problems: