BorlandTalk.com

Eric Harmon · Guest

Hi,

I have an app that ran just fine with the default instance of MSDE. I
changed the connection string in the app to work with a named instance
instead, like this: (local)/MyNamedInstance.

Database performance slowed measurably as soon as I did that, particularly
with DDL commands, like:

conn.Execute('CREATE DEFAULT BOOLEAN_DEFAULT AS ''F''');
conn.Execute('CREATE RULE BOOLEAN_RULE AS @list IN (''T'', ''F'')');

conn.Execute('sp_addtype DOM_BOOLEAN, ''VARCHAR(1)'', ''NOT NULL''');
conn.Execute('sp_bindefault BOOLEAN_DEFAULT, DOM_BOOLEAN');
conn.Execute('sp_bindrule BOOLEAN_RULE, DOM_BOOLEAN');

It literally takes 10-15 seconds to execute about 4 of these lines of code,
where they used to execute pretty much immediately.

Is there anything special I need to do with a named instance of MSDE to
obtain the same performance levels?

-Eric Harmon