diff options
| author | Terry Truong <terry06890@gmail.com> | 2022-05-10 19:07:02 +1000 |
|---|---|---|
| committer | Terry Truong <terry06890@gmail.com> | 2022-05-10 19:13:06 +1000 |
| commit | 9b4fd83e8f88858a7a8d440b129397561fb1fcac (patch) | |
| tree | 9a8a7ecc73b9bfda9e7221d502a0d1d87c078ad4 /backend/data/README.md | |
| parent | 3d895370a608d4f51726b74e2560dcf5f4ec43a8 (diff) | |
Split nodes table into nodes and edgessplit-nodes-table
This noticeably slowed server responses. Responses to a client's initial
node query slowed from 20-30ms to 200-300ms.
Diffstat (limited to 'backend/data/README.md')
| -rw-r--r-- | backend/data/README.md | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/backend/data/README.md b/backend/data/README.md index 9f0ea82..b3fd53b 100644 --- a/backend/data/README.md +++ b/backend/data/README.md @@ -3,8 +3,8 @@ File Generation Process 1 Tree Structure Data 1 Obtain data in otol/, as specified in it's README. - 2 Run genOtolData.py, which creates data.db, and adds a 'nodes' - table using data in otol/*. + 2 Run genOtolData.py, which creates data.db, and adds + 'nodes' and 'edges' tables using data in otol/*. 2 Name Data for Search 1 Obtain data in eol/, as specified in it's README. 2 Run genEolNameData.py, which adds 'names' and 'eol\_ids' tables to data.db, @@ -26,7 +26,9 @@ File Generation Process data.db tables ============== - nodes <br> - name TEXT PRIMARY KEY, children TEXT, parent TEXT, tips INT, p\_support INT + name TEXT PRIMARY KEY, tips INT +- edges <br> + node TEXT, child TEXT, p\_support INT, PRIMARY KEY (node, child) - names <br> name TEXT, alt\_name TEXT, pref\_alt INT, PRIMARY KEY(name, alt\_name) - eol\_ids <br> |