Subject Re: Running 2 .EXE files From Akshat Kapoor <akshat.kapoor@kapoorsons.in> Date Mon, 11 May 2020 08:05:29 -0400 Newsgroups dbase.getting-started Attachment(s) Printing _System INIT settings.pdf > Hi Guys, > > I am trying to run 2 x .exe files. > > The first one executes the second .exe via a run command and this seems to execute it and I can run as normal. I have a timer with a clock running and I can see it run as normal while I can execute the second file. However sometimes i get a \"database engine error\" or \"insufficient memory to run this operation\" > > However, this isnt the major problem, I reboot the computer and run them and it works. I keep a timer class running on the first file to check if records are updated from a database online and then update into local tables. > > It seems to work for a little while (say an hour or 2) but then the second .exe filters start to play up and it creates all types of errors. > > It seems the 2 x programs effect the common tables somehow even though they are running seperate exe\'s. > > So the question 1. is, how can I run concurrent .exe files that can talk to the same local database without effecting each other as if i am running 2 x seperate .exe\'s in seperate windows users? > > The second question is, I came from a Clipper background running dbase files and the drivers were extrordinarily quick and it didnt use a bde and I never had the above issue. When i say quick, i mean it never slowed done as much as dbase. Once I append over say 300,000 transactions in a file it slows to a crawl in dbase, but in the old days in clipper, I ran on pentium 2 computers and had files well over that than didnt slow at all, whats the difference and whats happened over the years??? > > However, my question is, is there anyway to run a third party driver to replace the BDE or is there something we can do (without converting millions of lines of code to sql) to enhance the bde to not slow so much with larger files? > > Any help would be greatly appreciated. Good Evening Michael, Is there an option of combining the two. Or running one of them without BDE (Chances are slim) BDE has not been updated for quiet some time and as far as I have heard at this newsgroup it cannot be updated. The older softwares had much lesser overhead and ran much faster than the current systems which provide for more functions but these overheads slow them down. Another question which version of dbase are you using. I have run multiple instances of plus 12 exe\'s at the same time but rarely face the issues you are telling (If it crops up then reboot is the only option). I have attached some system settings help file try modifying those. Regards Akshat