Even on a local drive with 2 connections to the db I saw a 6x difference. Gotta try it on a network db!!!!
Dennis McGrath ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, November 04, 2009 8:22 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Qualcols 2 vs 10, what do you giveupbychangingfrom 2 to 10? 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 100,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.
