Paradox Community

Items in pnews.paradox-client_server

Subject:Re: Performance problem opening database on SQL-server
Date:Sat, 21 Mar 2020 10:48:19 -0400
From:"Steven Green" <greens@diamondsg.com>
Newsgroups:pnews.paradox-client_server
and it doesn't matter if the other shop has that database open first or not?

--

Steven Green
Myrtle Beach, South Carolina, USA

http://www.OasisTradingPost.com

Collectibles and Memorabilia
Vintage Lego Sets and Parts
- and Paradox support, too
"Anders Jonsson"  wrote in message 
news:5e75edcc$1@pnews.thedbcommunity.com...

Yes, both shops connect to same server.

There are only 2 databases which both shops connect two..

The hardware is 100% the same.

Every setup should be the same as everything is created in code, the DSN
is created from Paradox by writing to the registry. Alias are created in
a start script.

This setup has workded for over 10 years for this client and other
clients have similar setup without problem.

What is really strange is that it's the opening of the database that
takes 100 times longer than normal. Once opened, other operations are
not affected.

So:

One SQL server with two databases

Shop 1 to Database A - OK
Shop 1 to Database B - OK
Shop 2 to Database A - Problem to Open, after that OK
Shop 2 to Database B - OK

It's just doesn't make any sense.

No, I haven't tried different DSN, that will be my next step. There must
be something causing this, but what?

Thanks for your input Tom!

Anders




Den 2020-03-21 kl. 10:06, skrev Tom Krieg:
> Do both shops connect to the same server? If so, are the 2 databases for 
> each shop unique? Or is Database 1 for Shop 1 the same database as 
> datbaase 1 for Shop 2?
>
> Have you tried a different DSN for each alias?


Copyright © 2004 thedbcommunity.com