Bob: Thanks for the testing! Since qualcols 10 is the default, your results show that you should not change it to 2 if you're going to be making table updates that affect a bunch of rows.
So... now I'm even more confused. I'm assuming that most people are running with qualcols 10 since it's the default (me included). The problem presented was how to speed up certain functions. Since qualcols 10 makes big operations much faster, wouldn't that be what you're concerned about? Why would you need qualcols 2 if perhaps that only works on smaller targeted sets of data? What am I missing? Karen > 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 > > > > >
