Changeset 180 for Doc/Backend/DBInterface.tex

Timestamp:

12/09/11 12:45:34 (13 years ago)

Author:

jkraaijeveld

Message:

Wrote more future work for documentation

File:

• Doc/Backend/DBInterface.tex (modified) (1 diff)

Doc/Backend/DBInterface.tex

@@ -220 +220 @@
                 does not exist.
 
+        \subsection{Optimize queries}
+                Queries as they are at the moment can be a bottleneck in performance if the sets get really large. This is because of a
+                couple of things. For one, there are duplicate queries being executed: if a Session object is retrieved, it also retrieves
+                all the corresponding AnswerSets, which in turn retrieves the corresponding Questions. However, the Session also
+                retrieves the Surveys related to it, which afterwards also retrieve the same questions. There has been no benchmarking
+                of performance so I have no clue at what size of the .rdf files this will become an issue.
+
+                I have a gut feeling that the SPARQL queries can be optimized some as well. This is regarding entries with zero or more
+                elements of a specific type, like Survey. Now, there is a second query for getting all the IDs for all the questions, but
+                there must be a way to introduce this into the first query without getting the exponential growth of the RDF 'different
+                tree options'.
+
+
 \appendix
 \pagebreak