From 9b4fd83e8f88858a7a8d440b129397561fb1fcac Mon Sep 17 00:00:00 2001
From: Terry Truong <terry06890@gmail.com>
Date: Tue, 10 May 2022 19:07:02 +1000
Subject: Split nodes table into nodes and edges

This noticeably slowed server responses. Responses to a client's initial
node query slowed from 20-30ms to 200-300ms.
---
 backend/data/README.md | 8 +++++---
 1 file changed, 5 insertions(+), 3 deletions(-)

(limited to 'backend/data/README.md')

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>
-- 
cgit v1.2.3