Method of Accelerating Complex SQL Requests
Peter Spaskovsky, George Venkov, Ralitza Krumova Kovacheva, Vesela Pasheva · AIP conference proceedings · 2011
The report presents a method of using a specific temporary table allowing significant acceleration in the execution of certain type complex dynamic SQL requests. The proposed approach is sufficiently general and allows optimizing requests with pre‐unknown structure that are formed in dialogue user mode. Within the study of performance a database of document exchange management system has been used under the operation of RDBMS Firebird 1.5. The discussed method is applicable to other RDBMS aiming at reducing the execution time of complexly structured SQL requests.