Karen, If you post a copy of the program code perhaps someone on the list can spot the problem line(s).
Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293 ________________________________ From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> To: RBASE-L Mailing List <[email protected]> Sent: Friday, December 5, 2008 11:42:05 AM 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
