Subject Running 2 processes or functions simultaneously
From Michael <michael@abstractservices.com.au>
Date Sun, 22 Jan 2023 21:51:26 -0500
Newsgroups dbase.getting-started

Hi Guys,

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?

Anyone? Any clue?

Thank You,

Michael.