From 0410fd4824fd898fab7815c6ef67b8e39bb6d2b9 Mon Sep 17 00:00:00 2001
From: Adam Ierymenko <adam.ierymenko@gmail.com>
Date: Tue, 28 Jun 2016 12:44:47 -0700
Subject: Refactor recent member request history to fix performance problem in
 controller.

---
 controller/SqliteNetworkController.hpp | 7 ++-----
 1 file changed, 2 insertions(+), 5 deletions(-)

(limited to 'controller/SqliteNetworkController.hpp')

diff --git a/controller/SqliteNetworkController.hpp b/controller/SqliteNetworkController.hpp
index e7cb937f..efeb63b1 100644
--- a/controller/SqliteNetworkController.hpp
+++ b/controller/SqliteNetworkController.hpp
@@ -137,11 +137,6 @@ private:
 	sqlite3_stmt *_sCreateMember;
 	sqlite3_stmt *_sGetNodeIdentity;
 	sqlite3_stmt *_sCreateOrReplaceNode;
-	sqlite3_stmt *_sGetMaxNodeHistoryNetworkVisitCounter;
-	sqlite3_stmt *_sAddNodeHistoryEntry;
-	sqlite3_stmt *_sDeleteOldNodeHistoryEntries;
-	sqlite3_stmt *_sGetActiveNodesOnNetwork;
-	sqlite3_stmt *_sGetNodeHistory;
 	sqlite3_stmt *_sGetEtherTypesFromRuleTable;
 	sqlite3_stmt *_sGetActiveBridges;
 	sqlite3_stmt *_sGetIpAssignmentsForNode;
@@ -167,8 +162,10 @@ private:
 	sqlite3_stmt *_sCreateIpAssignmentPool;
 	sqlite3_stmt *_sUpdateMemberAuthorized;
 	sqlite3_stmt *_sUpdateMemberActiveBridge;
+	sqlite3_stmt *_sUpdateMemberHistory;
 	sqlite3_stmt *_sDeleteMember;
 	sqlite3_stmt *_sDeleteAllNetworkMembers;
+	sqlite3_stmt *_sGetActiveNodesOnNetwork;
 	sqlite3_stmt *_sDeleteNetwork;
 	sqlite3_stmt *_sCreateRoute;
 	sqlite3_stmt *_sGetRoutes;
-- 
cgit v1.2.3