Gary, I'd suggest double-checking which fields you have indexed. I tried to find an older e-mail I sent about this, but I've experienced something very similar w/3-4 users. I checked my WHERE's and my ORDER BY's f/possible fields f/which to CREATE INDEX's. I did find a couple. Although it wasn't so critical in single-user, it appears that it's absolutely CRITICAL in multi-user to carefully consider what should be INDEXed. Anyway, thereafter, (just about all) multi-user performance was almost as quick as single-user, despite not having the best infrastructure.
BTW, we run NT-Server and WIN9x/2000, and the boxes are somewhat dated at this point. Also, you might look into TRANSACTION settings, but I don't know much about this. Just some ideas, Steve in Memphis ----- Original Message ----- From: "GARY Winzeler" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 26, 2002 11:07 AM 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/
