setting permanent optimizations

Post Reply
james120
Posts: 32
Joined: Tue Aug 31, 2004 7:42 pm

setting permanent optimizations

Post 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?
User avatar
John
Site Admin
Posts: 2622
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

setting permanent optimizations

Post by John »

They are not global or permanent, and need to be set on every connection to the database.
John Turnbull
Thunderstone Software
Post Reply