diff options
| author | Michael L. Young <elgueromexicano@gmail.com> | 2014-07-24 21:01:37 +0000 |
|---|---|---|
| committer | Michael L. Young <elgueromexicano@gmail.com> | 2014-07-24 21:01:37 +0000 |
| commit | 7059b001adb2583e1b6b2bb667d538df2fb3709b (patch) | |
| tree | 8d28011b42293166d2dbc4e58524384336ee1e74 /main/db.c | |
| parent | 7e78a8cb4df0378c398f7409665410e0aea596ff (diff) | |
core/db: Revert Patch Added In Attempt To Improve I/O Performance
Reverting the patch since it was causing a regression and after fixing the
regression, there were no performance gains. At least based on my method
for measurement.
ASTERISK-24050
Review: https://reviewboard.asterisk.org/r/3841/
git-svn-id: https://origsvn.digium.com/svn/asterisk/trunk@419504 65c4cc65-6c06-0410-ace0-fbb531ad65f3
Diffstat (limited to 'main/db.c')
| -rw-r--r-- | main/db.c | 2 |
1 files changed, 1 insertions, 1 deletions
@@ -119,7 +119,7 @@ static void db_sync(void); #define DEFINE_SQL_STATEMENT(stmt,sql) static sqlite3_stmt *stmt; \ const char stmt##_sql[] = sql; -DEFINE_SQL_STATEMENT(put_stmt, "INSERT OR IGNORE INTO astdb (key, value) VALUES (?1, ?2); UPDATE astdb SET value=?2 WHERE changes()=0 AND key=?1") +DEFINE_SQL_STATEMENT(put_stmt, "INSERT OR REPLACE INTO astdb (key, value) VALUES (?, ?)") DEFINE_SQL_STATEMENT(get_stmt, "SELECT value FROM astdb WHERE key=?") DEFINE_SQL_STATEMENT(del_stmt, "DELETE FROM astdb WHERE key=?") DEFINE_SQL_STATEMENT(deltree_stmt, "DELETE FROM astdb WHERE key || '/' LIKE ? || '/' || '%'") |