Thank you, Doug, I will add the 'SET NULL -0-' to the file today.
On Wednesday, March 5, 2025 at 10:52:02 PM EST, Doug Hamilton
<[email protected]> wrote:
Hi Jim -
Start up file:
I would add SET NULL -0- right after the first disconnect, ~line 11.
Otherwise it looks ok, could use some minor tweaking but critical multi-user
settings look good.
Make a backup of the database.
Give the startup a try and see if it helps performance.
Another thought:
Is the database on a dedicated server or is it on one of the workstations? A
dedicated server is recommended.
Best,
Doug
On 3/5/2025 8:41 PM, 'jim schmitt' via RBASE-L wrote:
Good Evening:
I have several clients , almost all of which are single users (not
networked). Now, with a new client with 3 computer connected to a network, I
may be in over my head. So, I am asking network people for suggestions.
, Operator 1 logs in and program runs fast, operator 2 longs in, and things
slow down, operator 3 logs in and this slow to a crawl. If fact, when they try
to enter a 9 digit account number, the digits entered display exceeding slow.
I've never used a 'start up' file, but after reading one of Razzak's 'From the
Edge' articles, I believe with a network, I need a start up file.
I've never used 'set STATICDB ON' OR 'SET ROWLOCKS ON' AS i haven't done
any networking.
So, I now have a start up file, and my questions are. Is this what I need
(code included), and will adding a start up file speed things up ? Do i need
to do more ? Other things ? Running out of time. Thanks in advance for any
suggestions.
Jim 1-614-361-3942
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/1132676101.694378.1741228875134%40mail.yahoo.com.
| | Virus-free.www.avast.com |
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/5f480029-72d4-459c-ae85-4d8977322eae%40wi.rr.com.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/1750588979.770109.1741250722500%40mail.yahoo.com.
