Hi Gary,
Minimize index columns for the tables involved. Verify Row may be
desirable for concurrent multi-user data entry environment.
Good Luck,
Manuel
GARY Winzeler wrote:
> 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/
