Page 1 of 1

setting permanent optimizations

Posted: Sat Sep 18, 2004 9:36 pm
by james120
I note that the docs say:

"The properties are set using the following SQL syntax:
SET property = value;"

does this mean that if I set keepnoise, matchmode, ignorecase, etc. using that syntax, that these changes will be global (applying to all users running queries against that database) and permanent (kept upon restart of server) until set otherwise? I am assuming yes, but if the answer is no, is there a way to make them global and permanent?

setting permanent optimizations

Posted: Mon Sep 20, 2004 11:15 am
by John
They are not global or permanent, and need to be set on every connection to the database.