Very interesting and impressive!
Tested on 100mb network. Database on file server and commands executed on work station. Feedback set to on for both tests. Test table has 1 00,900 rows (no indexes) Qualcol = 10 Update testtable set ItemStatus = 'Update Test 1' total update time = 3.672 seconds Same table, same test except QualCol = 2 Update testtable set ItemStatus = 'Update Test 2' Total update time = 8 minutes 24 seconds. That is a significant difference! -Bob ----- Original Message ----- From: "A. Razzak Memon" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Wednesday, November 4, 2009 7:50:04 AM GMT -06:00 US/Canada Central Subject: [RBASE-L] - RE: Qualcols 2 vs 10, what do you giveupbychanging from 2 to 10? At 08:00 AM 11/4/2009, Dennis McGrath wrote: >Razzak, > >Just to clarify. >I can have the DB open and change QUALCOLS on the fly? > >So the following code would work without any problem > >SET QUALCOLS 10 -- change to page locking >UPDATE whatever >SET QUALCOLS 2 -- change to row locking Very correct, Dennis! To observe the actual difference, if you are using the latest version and updates of R:BASE 7.6 or Turbo V-8, you can try the following ... -- R:BASE 7.6 for Windows (Build:7.6.8.31102 or higher) -- R:BASE Turbo V-8 for Windows (Build:8.0.22.31102 or higher) SET FEEDBACK ON SET QUALCOLS 10 -- change to page locking UPDATE whatever SET QUALCOLS 2 -- change to row locking SET FEEDBACK OFF CLS Very Best R:egards, Razzak.
