mirror of
https://github.com/NVIDIA/OpenShell.git
synced 2026-10-19 05:50:41 +08:00
Drew Newberry
33bbda3d33
* refactor(persistence): adopt continuation-token pagination Signed-off-by: Drew Newberry <anewberry@nvidia.com> * fix(pagination): address continuation review findings Signed-off-by: Drew Newberry <anewberry@nvidia.com> * fix(tui): recover completed list refreshes Signed-off-by: Drew Newberry <anewberry@nvidia.com> * fix(pagination): address review scalability findings Signed-off-by: Drew Newberry <anewberry@nvidia.com> * fix(pagination): repair branch validation Signed-off-by: Drew Newberry <anewberry@nvidia.com> * docs(go): use page size in template example Signed-off-by: Drew Newberry <anewberry@nvidia.com> --------- Signed-off-by: Drew Newberry <anewberry@nvidia.com>
7 lines
349 B
SQL
7 lines
349 B
SQL
-- Support workspace-scoped and platform-wide keyset pagination orderings.
|
|
CREATE INDEX IF NOT EXISTS objects_workspace_page_idx
|
|
ON objects (object_type, workspace, created_at_ms, COALESCE(name, ''), id);
|
|
|
|
CREATE INDEX IF NOT EXISTS objects_all_workspaces_page_idx
|
|
ON objects (object_type, created_at_ms, COALESCE(name, ''), workspace, id);
|