summaryrefslogtreecommitdiff
path: root/cdr
diff options
context:
space:
mode:
authorSean Bright <sean@malleable.com>2010-06-08 15:39:52 +0000
committerSean Bright <sean@malleable.com>2010-06-08 15:39:52 +0000
commit285ef284efa124db6de7d6334ce6c8c2d59d811c (patch)
tree5bd03fdd807b49b627335f97c6a84a3117f88310 /cdr
parentdbd3233445307d68eca2986c4596d0c531b228cd (diff)
Merged revisions 269006 via svnmerge from
https://origsvn.digium.com/svn/asterisk/branches/1.4 ........ r269006 | seanbright | 2010-06-08 11:28:49 -0400 (Tue, 08 Jun 2010) | 11 lines Reduce startup time for cdr_tds with large CDR tables. Since we are just checking for table existence, add a WHERE clause that will return no rows but will raise an error if the table doesn't exist. (closes issue #17380) Reported by: kkwong Patches: issue17380-01.patch uploaded by seanbright (license 71) Tested by: kkwong ........ git-svn-id: https://origsvn.digium.com/svn/asterisk/trunk@269007 65c4cc65-6c06-0410-ace0-fbb531ad65f3
Diffstat (limited to 'cdr')
-rw-r--r--cdr/cdr_tds.c2
1 files changed, 1 insertions, 1 deletions
diff --git a/cdr/cdr_tds.c b/cdr/cdr_tds.c
index 4fcccae62..c615400d3 100644
--- a/cdr/cdr_tds.c
+++ b/cdr/cdr_tds.c
@@ -357,7 +357,7 @@ static int mssql_connect(void)
goto failed;
}
- if (execute_and_consume(settings->dbproc, "SELECT 1 FROM [%s]", settings->table)) {
+ if (execute_and_consume(settings->dbproc, "SELECT 1 FROM [%s] WHERE 1 = 0", settings->table)) {
ast_log(LOG_ERROR, "Unable to find table '%s'\n", settings->table);
goto failed;
}