On the hardware side, for Win2000 OS, check 'NIC properties' (or your PCI adapter properties for the NIC you're using). We found the default setting of "Auto Detect" deficient under "Link Speed & Duplex", and set to 100Mbps/FullDuplex. In our case, improved multi-user performance 400% within Rbase apps. If you have 100Mbps NIC's you may want to check each station's settings.... Just a thought.
Regards, Brad Dan Goldberg wrote: > 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/
begin:vcard n:Davidson;Brad tel;fax:909-736-4699 tel;work:909-736-4690 x-mozilla-html:FALSE url:www.aero-craft.com org:Aero-Craft Hydraulics, Inc.;Customer Support, MIS adr:;;392 North Smith Avenue;Corona;CA;92880-6971;USA version:2.1 email;internet:[EMAIL PROTECTED] title:Manager fn:Brad Davidson end:vcard
