Emmitt: This IS running in DOS only, so that's why there's DOS-only commands still in there. We still have about a couple dozen programs we haven't yet upgraded to 7.6 (the really hairy ones). But apparently even when their entire app was in DOS it was probably running slow because of something in this setup file.
We have MANOPT OFF as the default. Don't want to mess with setting it on since we have never programmed with that in mind .. Could make more things worse, than things better. I'll have to check if SET SCRATCH TMP was available in DOS 6.5; don't think it was. Yes, the settings are prior to connecting. I don't even know what SORT MAX is! I'll have to read up on it and see if that could be the problem. Thanks for looking! Karen > Karen, > > I’d comment out the SET SORT MAX near the end. I presume that all this is > run prior to connecting the database, since several of the commands herein > will have no impact if you connect first. > > I’d also reduce all of the commands relating to scratch to simply this: > > SET SCRATCH TMP > > If STATICDB is ON, then I’d also SET FASTLOCK ON. These, too, need to be > executed prior to connecting the database. Both require that all users run > with the same settings. > > What about MANOPT? I don’t see it in the list. For certain queries, > especially well-constructed multi-table SELECTs, it can speed things > tremendously. > > SET FILES 25 might be a detriment. That’s an old DOS days setting. > Depending on what your process is doing, it might be a limitation. RBG7x is > going > to create more $$$ files than DOS. Try 50 or 60. > > > > >
