Dennis: no, no, that's not what I'm talking about! I'm not saying that there's a performance hit or time delay simply by running this program. The program itself is almost instantaneous.
What I'm saying is that after you run this setting program, a particular program runs 10 times slower! If I simply connect the database, the program takes 1 min. to run. If I run this "setup" program that applies these settings, then the same program takes 10 to 12 minutes to run! Karen > Yes, I understand, if you just change to the owner and force the settings > to the correct values there can be a huge time delay. > > My code avoids all the time consuming stuff because normally it does > NOTHING except check the values of the settings. > > It also tried to just do those that are stored with the DB, as those are > the only ones which will be wrong if you are managing your CFG files properly. > > It also makes the changes so they stick when the db is closed > > If it frequently has to fix a setting that someone or something is changing > as an owner, That needs to be fixed. > > It could be updated so any change it does make is documented in a table so > you can check on that scenario. > > > > Hmm I bet Howard is using a very old version of this code!!!! I may have > written it! I wrote the original version over 20 years ago. I took the > concept with me when Howard hired me two employers ago! > > > > The one in my email solved all those problems and our DBs connect very fast > now. > > That was when we still had a lot of wireless network connections (Interpret > SLOW!) > > Changing some settings takes a significant amount of network traffic. > > > > Denni > > >
