I have created database (very large database) of questions using datatool as
\DTLnewdb{finitemath}
\long\def\newproblem#1#2#3#4#5#6#7#8#9{%
\DTLnewrow{finitemath}%
\DTLnewdbentry{finitemath}{seq}{#1}%
\DTLnewdbentry{finitemath}{yr}{#2}%
\DTLnewdbentry{finitemath}{sub}{#3}%
\DTLnewdbentry{finitemath}{top}{#4}%
\DTLnewdbentry{finitemath}{mar}{#5}%
\DTLnewdbentry{finitemath}{qus}{#6}%
\DTLnewdbentry{finitemath}{url}{#7}%
\DTLnewdbentry{finitemath}{exp}{#8}%
\DTLnewdbentry{finitemath}{ans}{#9}%
}
\newproblem{1}{2018}{DM}{comb}{1}{
\textbf{Which one of the following\begin{lstlisting}
is a closed form expression for the generating function of\end{lstlisting}
the sequence $\{a_n\}$, where $a_n = 2n +3 \text{ for all } n=0, 1, 2, \dots$?}\\
$($A$)$ $\frac{3}{(1-x)^2}$\\
$($B$)$ $\frac{3x}{(1-x)^2}$\\
$($C$)$ $\frac{2-x}{(1-x)^2}$\\
$($D$)$ $\frac{3-x}{(1-x)^2}$\\
}{\url{http://gatefreaks.com/index.php?qa=9036&qa_1=dm-gate-2015-3-1}}{.}{Ans:d}
Database has 9 different columns.I have 10 such database files .I use master file to combine all these database and when i compile it output a sorted pdf file (acc to any of the field). But compilation takes hours. Is there any way to make it efficient.
I read somewhere that it can be done using datatooltk.But i am not able to figure out, how to import my database to datatooltk? Is there any other way of doing it ?