From 0da95dcf912658ec3e4385c8969f43f666c0e27d Mon Sep 17 00:00:00 2001 From: Sree Harsha Totakura Date: Tue, 7 Jan 2014 09:31:13 +0000 Subject: [PATCH] - use asynchronous to speedup sqlite db writes --- src/testbed/generate-underlay-topology.c | 13 ++++--------- 1 file changed, 4 insertions(+), 9 deletions(-) diff --git a/src/testbed/generate-underlay-topology.c b/src/testbed/generate-underlay-topology.c index 4299795a5..985c8e32e 100644 --- a/src/testbed/generate-underlay-topology.c +++ b/src/testbed/generate-underlay-topology.c @@ -149,24 +149,21 @@ setup_db (const char *dbfile) " ?3," " ?4," " ?5);"; - struct sqlite3_stmt *stmt_create; int ret; - stmt_create = NULL; if (SQLITE_OK != (ret = sqlite3_open (dbfile, &db))) { LOG_SQLITE (db, NULL, GNUNET_ERROR_TYPE_ERROR, "sqlite3_open"); goto err_ret; } - if (SQLITE_OK != (ret = sqlite3_prepare_v2 (db, query_create, -1, - &stmt_create, NULL))) + if (0 != sqlite3_exec (db, query_create, NULL, NULL, NULL)) { - LOG_SQLITE (db, NULL, GNUNET_ERROR_TYPE_ERROR, "sqlite3_prepare_v2"); + LOG_SQLITE (db, NULL, GNUNET_ERROR_TYPE_ERROR, "sqlite3_exec"); goto err_ret; } - if (SQLITE_DONE != sqlite3_step (stmt_create)) + if (0 != sqlite3_exec (db, "PRAGMA synchronous = 0;", NULL, NULL, NULL)) { - LOG_SQLITE (db, NULL, GNUNET_ERROR_TYPE_ERROR, "sqlite3_step"); + LOG_SQLITE (db, NULL, GNUNET_ERROR_TYPE_ERROR, "sqlite3_exec"); goto err_ret; } if (SQLITE_OK != (ret = sqlite3_prepare_v2 (db, query_insert, -1, @@ -177,8 +174,6 @@ setup_db (const char *dbfile) } err_ret: - if (NULL != stmt_create) - sqlite3_finalize (stmt_create); return (SQLITE_OK != ret) ? GNUNET_SYSERR : GNUNET_OK; } -- 2.25.1