Assuming nothing has changed with the network, and R:base itself is running slower, I would reload the database to start with. This will rebuild all of the indexes and recompute all of the query optomizer information.
Try setting the variable microrim_f3maxblk = 128 before connecting to the database. This setting effects the amount of memory that is allocated to doing indexed operations. I am not sure if it will effect inserts or not. You might want to try setting your qualcols from 2 to 10. This will change the database from row locking to page locking, and quite often will improve performance. A few minutes for an insert, this really sounds like a network problem possably having something to do with file sharing??? Is it an insert of values, or are you selecting information from another table for the insert? Troy Sosamon ===== Original Message from [EMAIL PROTECTED] at 9/26/02 10:07 am >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/
