diff options
| author | Adam Ierymenko <adam.ierymenko@gmail.com> | 2016-06-28 12:44:47 -0700 |
|---|---|---|
| committer | Adam Ierymenko <adam.ierymenko@gmail.com> | 2016-06-28 12:44:47 -0700 |
| commit | 0410fd4824fd898fab7815c6ef67b8e39bb6d2b9 (patch) | |
| tree | daac3c5835c7cb19e7290624873bf8405bab6625 /controller/schema.sql.c | |
| parent | 02fa32422aeab4eae27e290387182de9371818c9 (diff) | |
| download | infinitytier-0410fd4824fd898fab7815c6ef67b8e39bb6d2b9.tar.gz infinitytier-0410fd4824fd898fab7815c6ef67b8e39bb6d2b9.zip | |
Refactor recent member request history to fix performance problem in controller.
Diffstat (limited to 'controller/schema.sql.c')
| -rw-r--r-- | controller/schema.sql.c | 22 |
1 files changed, 5 insertions, 17 deletions
diff --git a/controller/schema.sql.c b/controller/schema.sql.c index 5c21403a..dab34138 100644 --- a/controller/schema.sql.c +++ b/controller/schema.sql.c @@ -34,23 +34,6 @@ " identity varchar(4096) NOT NULL\n"\ ");\n"\ "\n"\ -"CREATE TABLE NodeHistory (\n"\ -" nodeId char(10) NOT NULL REFERENCES Node(id) ON DELETE CASCADE,\n"\ -" networkId char(16) NOT NULL REFERENCES Network(id) ON DELETE CASCADE,\n"\ -" networkVisitCounter INTEGER NOT NULL DEFAULT(0),\n"\ -" networkRequestAuthorized INTEGER NOT NULL DEFAULT(0),\n"\ -" requestTime INTEGER NOT NULL DEFAULT(0),\n"\ -" clientMajorVersion INTEGER NOT NULL DEFAULT(0),\n"\ -" clientMinorVersion INTEGER NOT NULL DEFAULT(0),\n"\ -" clientRevision INTEGER NOT NULL DEFAULT(0),\n"\ -" networkRequestMetaData VARCHAR(1024),\n"\ -" fromAddress VARCHAR(128)\n"\ -");\n"\ -"\n"\ -"CREATE INDEX NodeHistory_nodeId ON NodeHistory (nodeId);\n"\ -"CREATE INDEX NodeHistory_networkId ON NodeHistory (networkId);\n"\ -"CREATE INDEX NodeHistory_requestTime ON NodeHistory (requestTime);\n"\ -"\n"\ "CREATE TABLE IpAssignment (\n"\ " networkId char(16) NOT NULL REFERENCES Network(id) ON DELETE CASCADE,\n"\ " nodeId char(10) REFERENCES Node(id) ON DELETE CASCADE,\n"\ @@ -80,12 +63,17 @@ " activeBridge integer NOT NULL DEFAULT(0),\n"\ " memberRevision integer NOT NULL DEFAULT(0),\n"\ " flags integer NOT NULL DEFAULT(0),\n"\ +" lastRequestTime integer NOT NULL DEFAULT(0),\n"\ +" lastPowDifficulty integer NOT NULL DEFAULT(0),\n"\ +" lastPowTime integer NOT NULL DEFAULT(0),\n"\ +" recentHistory blob,\n"\ " PRIMARY KEY (networkId, nodeId)\n"\ ");\n"\ "\n"\ "CREATE INDEX Member_networkId_nodeId ON Member(networkId,nodeId);\n"\ "CREATE INDEX Member_networkId_activeBridge ON Member(networkId, activeBridge);\n"\ "CREATE INDEX Member_networkId_memberRevision ON Member(networkId, memberRevision);\n"\ +"CREATE INDEX Member_networkId_lastRequestTime ON Member(networkId, lastRequestTime);\n"\ "\n"\ "CREATE TABLE Route (\n"\ " networkId char(16) NOT NULL REFERENCES Network(id) ON DELETE CASCADE,\n"\ |