diff options
| author | piaip <piaip@63ad8ddf-47c3-0310-b6dd-a9e9d9715204> | 2009-06-20 19:48:15 +0800 |
|---|---|---|
| committer | piaip <piaip@63ad8ddf-47c3-0310-b6dd-a9e9d9715204> | 2009-06-20 19:48:15 +0800 |
| commit | 34bdef4d512cd8c2385480bca0c34c55a39534de (patch) | |
| tree | a176bb2c69c011b383b3776e902d990434bc0f9b | |
| parent | 43681fc130abb9cce56ad5435fb6159ea7a8527f (diff) | |
| download | pttbbs-34bdef4d512cd8c2385480bca0c34c55a39534de.tar pttbbs-34bdef4d512cd8c2385480bca0c34c55a39534de.tar.gz pttbbs-34bdef4d512cd8c2385480bca0c34c55a39534de.tar.bz2 pttbbs-34bdef4d512cd8c2385480bca0c34c55a39534de.tar.lz pttbbs-34bdef4d512cd8c2385480bca0c34c55a39534de.tar.xz pttbbs-34bdef4d512cd8c2385480bca0c34c55a39534de.tar.zst pttbbs-34bdef4d512cd8c2385480bca0c34c55a39534de.zip | |
* speed up sql command
git-svn-id: http://opensvn.csie.org/pttbbs/trunk/pttbbs@4681 63ad8ddf-47c3-0310-b6dd-a9e9d9715204
| -rw-r--r-- | daemon/regmaild/regmaild.c | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/daemon/regmaild/regmaild.c b/daemon/regmaild/regmaild.c index eabc45c8..3c2a7f90 100644 --- a/daemon/regmaild/regmaild.c +++ b/daemon/regmaild/regmaild.c @@ -177,7 +177,8 @@ regmaildb_check_email(const char * email, int email_len, const char *myid) else if (regmaildb_open(&Db, EMAILDB_PATH) != SQLITE_OK) goto end; - if (sqlite3_prepare(Db, "SELECT userid FROM emaildb WHERE email LIKE lower(?);", + // XXX == is faster than LIKE in this case, although it does not support '%' and case sensitive + if (sqlite3_prepare(Db, "SELECT userid FROM emaildb WHERE email == lower(?);", -1, &Stmt, NULL) != SQLITE_OK) goto end; @@ -233,7 +234,7 @@ regmaildb_update_email(const char * userid, int userid_len, const char * email, if (strcmp(email, "x") == 0) { - if (sqlite3_prepare(Db, "DELETE FROM emaildb WHERE userid like lower(?);", + if (sqlite3_prepare(Db, "DELETE FROM emaildb WHERE userid == lower(?);", -1, &Stmt, NULL) != SQLITE_OK) goto end; |