don't put exclusive locks on capacls and alias tables (almost every

query reads them, few write them).

diff --git a/server/qrtn.qc b/server/qrtn.qc
index ec9cbe316a5f8a48a22f35b079d5d757741f8d8e..7575f78d630640a5a158491759dbfce6f4a95fec 100644 (file)
--- a/server/qrtn.qc
+++ b/server/qrtn.qc
@@ -81,6 +81,8 @@ int sms_open_database()
     /* open the database */
 ##  ingres sms
 ##  set lockmode session where level = table, timeout = query_timeout
+##  set lockmode on capacls where readlock = shared
+##  set lockmode on alias where readlock = shared
     return ingres_errno;
 }