mirror of
https://github.com/lux-apps/papers.git
synced 2026-10-30 18:15:21 +00:00
zeekay
abf99d05fc
Restructured from flat .tex/.pdf files into per-paper subdirectories. Added Antje Worring as co-author on all papers. Synced PDFs to pdfs/ for download site.
25 lines
677 B
TeX
25 lines
677 B
TeX
\section{Appendix C: Query Optimization Techniques}
|
|
|
|
|
|
\textbf{Index Selection:}
|
|
\begin{itemize}
|
|
\item Use custom indexes for filtered queries
|
|
\item Leverage Verkle tree structure for membership proofs
|
|
\item Maintain separate indexes for high-cardinality fields
|
|
\end{itemize}
|
|
|
|
\textbf{Query Caching:}
|
|
\begin{itemize}
|
|
\item Cache query results for 1 block (~500ms)
|
|
\item Cache compiled bytecode for registered queries
|
|
\item LRU cache for frequently accessed nodes
|
|
\end{itemize}
|
|
|
|
\textbf{Batch Processing:}
|
|
\begin{itemize}
|
|
\item Batch node lookups into single BadgerDB transaction
|
|
\item Parallelize independent subqueries
|
|
\item Prefetch nodes during edge traversal
|
|
\end{itemize}
|
|
|