Subject Re: Running 2 processes or functions simultaneously
From Michael <>
Date Mon, 23 Jan 2023 16:25:43 -0500
Newsgroups dbase.getting-started

Hi Akshat,

That was my first thought, run a seperate .exe in low priority in the background but I never had success running multiple exe's. They would eventually conflict or crash, if they ran at all. I would always get an insufficient resources to run this executable message. Is there any special settings I need to put in the BDE to be able to run a second exe or special commands within the program to run independantly?


Akshat Kapoor Wrote:

> Good Morning Michael,
> > I have a dilemma. I have a legacy software package I have been extending and building on since 2003. Currently its in DBASE 11 and runs very well , even in windows 11.
> >
> > My probrlem is, I want to create an online portal and build a dashboard for my data.
> >
> > I have developed a nice function to update a database online and a php script to receive the data and write to the sql database. As my local files are legacy dbase files and its too much developement involved to change that into sql or Maria db, I wrote the function above and it works nicely. However, I want to run this in the background in low memory or even as a seperate user set as to not effect the running of the front end user software.
> >
> > I can use timer to run and check any updates every 10 secs or so and then write it to the web server but it will lagg the user if he is using the software front end at the same time. It seems to be either one or the other process and it switches between the 2.
> >
> > Is there a way, i can run the function as a seperate process at low level processor as to continually work without disrupting the main software usage?
> >
> > Similar to running a seperate user in windows, each user can run simultaneously and not effect each other so much. How can we do this in DBASE?
> There is no limitation to the number of dbase exe running. So build a
> separate exe for updating the mysql database.
> On my main computer 3 exe run most of the time.
> 1. The main app
> 2. A exe to generate a slide show to be displayed on a android TV
> 3. A exe to display some data on second monitor.
> The first is event driven (wait for user command). Rest 2 are running on
> timers and do not require user intervention.
> Regards
> Akshat