That is really weird! Try my program (just adjust the settings I've used to your liking) and see if it cases the same problem.)
Also compare the setting when you first connect to the db and after that rogue program runs. MANOPT is one setting that might have a significant affect on the program performance. Some programs run faster with it on and others run faster with it off. Dennis ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, December 05, 2008 11:42 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Running 7.6 code from a batch? 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
