14 lines
1.1 KiB
TeX
14 lines
1.1 KiB
TeX
\begin{tabular}{|r|c|c|c|c|c|c|}\hline
|
|
\ \ \textbf{Operation}\ \ & \texttt{SELECT} & \texttt{INSERT} & \texttt{UPSERT} & \texttt{UPDATE} & \texttt{DELETE} & \textbf{Total}\\\hline
|
|
\textbf{\ \ Count } & \ \ 33,470,310\ \ & \ \ 1,953,279\ \ & \ \ 7,376,648\ \ & \ \ 1,041,967\ \ & \ \ 1,248,594\ \ & \ \ 45,090,798\ \ \\\hline
|
|
\textbf{\ \ Runtime (ms) } & \ \ 1.13\ \ & \ \ 2.31\ \ & \ \ 0.93\ \ & \ \ 6.59\ \ & \ \ 3.78\ \ & \\\hline
|
|
\multicolumn{7}{|c|}{\textbf{Features Used}}\\\hline
|
|
\texttt{OUTER JOIN} & \ \ 391,052\ \ & & & & \ \ 236\ \ & \ \ 391,288\ \ \\\hline
|
|
\texttt{DISTINCT} & \ \ 1,888,013\ \ & & & \ \ 25\ \ & \ \ 5,586\ \ & \ \ 1,893,624\ \ \\\hline
|
|
\texttt{LIMIT} & \ \ 1,165,096\ \ & & & & \ \ 422\ \ & \ \ 1,165,518\ \ \\\hline
|
|
\texttt{ORDER BY} & \ \ 3,168,915\ \ & & & & \ \ 194\ \ & \ \ 3,169,109\ \ \\\hline
|
|
\texttt{Aggregate} & \ \ 638,137\ \ & & & \ \ 25\ \ & \ \ 3,190\ \ & \ \ 641,352\ \ \\\hline
|
|
\texttt{GROUP BY} & \ \ 438,919\ \ & & & \ \ 25\ \ & & \ \ 438,944\ \ \\\hline
|
|
\texttt{UNION} & \ \ 13,801\ \ & & & & \ \ 65\ \ & \ \ 13,866\ \ \\\hline
|
|
\end{tabular}
|