There are many things to consider with multi-user performance issues. You must consider hardware/network issues, software issues(virus scanners,etc) as well as database design issues.
Hardware/network: switches vs hubs 100mb vs 10mb user/server computer performance(memory, mhz, etc.) Software: Virus scanners(not to scan database files) Database design: using constraints instead of rules when possible(constraints are much faster than rules). using temp tables/views to improve speed. I am sure I missed alot of things but this should give you an idea. I used to have problems with performance but I have found solutions for all them. There is always a solution to performance problems. Dan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of GARY Winzeler Sent: Thursday, September 26, 2002 9:08 AM To: [EMAIL PROTECTED] Subject: Multi-User speed change I have a client that has been using Rbase 6.5++ latest version, for a while now and recently they have been adding rows to a database (Presently they have about 28,000 rows). the added rows are parts list that they are adding and recently put 3 or 4 people on for data entry. They are seeing a very large time delay with the added people - from a few seconds to in some cases a few minutes with 3-4 people. Does anyone have any suggestions on tuning the system to improve the speed? The current setting are: AUTOCOMM OFF AUTOCONV OFF AUTORECO OFF AUTOROWV OFF AUTOSYNC OFF AUTOUPGR OFF COMPATIB ON LOOKUPS 8 QUALCOLS 2 MULTI ON STATICDB ON NAME YO VERIFY COLUMN ROWLOCKS ON FASTLOCK ON WAIT 1 INTERVAL 5 REFRESH 0 TRANSACT OFF MAXTRANS 10 MDI ON AUTODROP OFF ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
