The MICRORIM_F2MAXBLK, F3, TMP, and BT variables control the allocated memory R:base uses to retreive and sort data. F2 is for non indexed data access, F3 is for indexed data access, TMP and BT are the same for temporary tables. The best settings vary from machine to machine. Try F2 at 128 and F3 at 256. Try setting multi off and see how that effects things. Is this a single user db w/ the db being accessed from the same machine that it is on?
I think other's that have had problems w/ NT found it to be a networking/protocall mis configuration problems. Troy Sosamon ===== Original Message from [EMAIL PROTECTED] at 10/06/01 11:30 pm >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]
