| Subject: | Re: Performance problem opening database on SQL-server
| | Date: | Sun, 22 Mar 2020 09:51:52 +0100
| | From: | Anders Jonsson <andersREMOVETHIS@jonssondata.se>
| | Newsgroups: | pnews.paradox-client_server
|
Den 2020-03-21 kl. 15:48, skrev Steven Green:
> and it doesn't matter if the other shop has that database open first or
> not?
No.
The app is written so that the database is opened, then some SQL-calls
and then the db varialbe is closed. This happens hundred of times each day.
Most of my testing so far as been of business hours where the other shop
is closed.
Originally this company had 17 shops but is now down to 2. It has been
working for years. Only thing that is new is the fact that we just
installed new PCs with Win 10.
One shop is OK, the other not.
|
