I have been trying to speed up RB6.5++ on a Win2000 server and have been trying different selected settings. I have some observations and questions about those settings.
There is a setting called SORT MAX. If you enter SHOW SORT MAX, you get a result of 128. You can change this value by entering, for example, SET SORT MAX 64. I don't see any info in the on-line documentation about this setting. What does it do and is the default value of 128 a good value or should it be higher or lower (under what circumstances)? The other "setting" is the value of the variables MICRORIM_F2MAXBLK and MICRORIM_F3MAXBLK. I ran a speed comparison test running a command file containing a set of CROSSTAB commands. When I ran the test, without setting these two variables, it took 270 seconds (RB6.5++ DOS) and 222 seconds (RB6.5++ WIN). The default value for these variables are 6 and 32 respectively. I then set the variables as follows: DISCO;SET V MICRORIM_F2MAXBLK = 48, MICRORIM_F3MAXBLK = 256 I then connected the database and ran the time test. It took 90 seconds (RB6.5++ DOS) and 65 seconds (RB6.5++ WIN). This is about 3 times faster. What values are reasonable for these variables and what is the maximum value? Has anyone else had any experience using these variables? Frank Radice [EMAIL PROTECTED]
