From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from smtp39.i.mail.ru (smtp39.i.mail.ru [94.100.177.99]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by dev.tarantool.org (Postfix) with ESMTPS id E13AE45C304 for ; Fri, 11 Dec 2020 01:38:50 +0300 (MSK) From: Leonid Vasiliev Date: Fri, 11 Dec 2020 01:37:50 +0300 Message-Id: <848e5b2fe5d1b8da491759a07abc035142280638.1607638829.git.lvasiliev@tarantool.org> Subject: [Tarantool-patches] [PATCH] sql: increase default cache size List-Id: Tarantool development patches List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , To: v.shpilevoy@tarantool.org, imeevma@tarantool.org, korablev@tarantool.org, sergos@tarantool.org Cc: tarantool-patches@dev.tarantool.org Increase the maximum number of in-memory pages to use for temporary tables. (https://www.sqlite.org/compile.html#default_cache_size) Part of #5609 --- Hi SQL team. It is a simplest part of #5609. This patch increases the default SQL cache size by 10 times to 20 MB. A similar experiment shows a 10% performance increase for some datasets. (https://github.com/tarantool/tarantool/issues/5593#issuecomment-740044007). Mons approved these changes. I haven't done any research to determine the optimal value. So feel free to throw this patch away. https://github.com/tarantool/tarantool/issues/5609 https://github.com/tarantool/tarantool/tree/lvasiliev/gh-5609-increase-default-sql-sort-cache-size src/box/CMakeLists.txt | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/src/box/CMakeLists.txt b/src/box/CMakeLists.txt index 19203f7..7372179 100644 --- a/src/box/CMakeLists.txt +++ b/src/box/CMakeLists.txt @@ -218,6 +218,10 @@ if(CMAKE_BUILD_TYPE STREQUAL "Debug") add_definitions(-DSQL_DEBUG=1) endif() add_definitions(-DSQL_TEST=1) +# Set the maximum number of in-memory pages to use for temporary tables. +# 20000 * 1024 = 20480000 bytes. +# (https://www.sqlite.org/compile.html#default_cache_size) +add_definitions(-DSQL_DEFAULT_CACHE_SIZE=-20000) set(EXT_SRC_DIR ${CMAKE_SOURCE_DIR}/extra) set(EXT_BIN_DIR ${CMAKE_BINARY_DIR}/extra) -- 2.7.4