Skip to content
This repository was archived by the owner on Sep 9, 2025. It is now read-only.

Storage: Add Indexes for common queries #308

Merged
hendrikvanantwerpen merged 4 commits into from
Aug 9, 2023
Merged

Storage: Add Indexes for common queries #308

Changes from 1 commit
Commits
Show all changes
4 commits
Select commit Hold shift + click to select a range
1f5de0e
Storage: Add Indexes for common queries
wmanley Aug 7, 2023
07e72e1
Do not use covering indices to reduce database size
Aug 9, 2023
134b7bc
Also initialize indices from reader
Aug 9, 2023
ddafce4
Update authors
Aug 9, 2023
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
Next Next commit
Do not use covering indices to reduce database size
  • Loading branch information
Hendrik van Antwerpen
Hendrik van Antwerpen committed Aug 9, 2023
commit 07e72e167f174f865fcc72533cf800019056678d
6 changes: 3 additions & 3 deletions stack-graphs/src/storage.rs
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -59,9 +59,9 @@ const SCHEMA: &str = r#"
"#;

const INDEXES: &str = r#"
CREATE INDEX IF NOT EXISTS graph_file_value ON graph(file, value);
CREATE INDEX IF NOT EXISTS file_paths_file_local_id_value ON file_paths(file, local_id, value);
CREATE INDEX IF NOT EXISTS root_paths_symbol_stack_file_value ON root_paths(symbol_stack, file, value);
CREATE INDEX IF NOT EXISTS idx_graphs_file ON graphs(file);
CREATE INDEX IF NOT EXISTS idx_file_paths_local_id ON file_paths(file, local_id);
CREATE INDEX IF NOT EXISTS idx_root_paths_symbol_stack ON root_paths(symbol_stack);
"#;

const PRAGMAS: &str = r#"
Expand Down