||Re: Running 2 processes or functions simultaneously
Akshat Kapoor <firstname.lastname@example.org>
||Mon, 23 Jan 2023 11:12:26 +0530
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.