From 9d47e55535d56fb2219e5900ab48bc2540693d21 Mon Sep 17 00:00:00 2001 From: Jan Vales Date: Mon, 8 Apr 2019 11:50:31 +0200 Subject: [PATCH] added discussion. --- ex1/main_4.tex | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/ex1/main_4.tex b/ex1/main_4.tex index 15916df..c8ca370 100644 --- a/ex1/main_4.tex +++ b/ex1/main_4.tex @@ -101,6 +101,9 @@ Execution time: query-timeout \end{verbatim} +Changing the create numbers definitely impacts performance. The question is what is part of the assignment and what not. + + \item create indices. \begin{verbatim} @@ -345,4 +348,6 @@ Planning time: 0.978 ms Execution time: 2040.407 ms \end{verbatim} +We suspect that performance varies likely because the dataset is not a balanced triangle and in some cases results can be discarded earlier. Also resultset deduplication may play a role. + \end{enumerate} -- 2.43.0