In memory database, shared memory, etc
Posted on 2004-09-13
We have an application that is real-time and must update every second. Sadly, we are using MS Access as are database.
The issue is the front end is handling drawing all the information on the screen which it gets from the database, and we have another service that uses a socket to retrieve info from a unix system and put this info into the MS Access DB.
I'm really worried about speed and having the socket program write all the time, it failing etc.
Isn't there a way i can do shared memory between applications in some sort of DLL? Or is there a better mechanism between sharing high speed data between two apps (one running vb 6.0 right now, soon to be C#), other application is C#.
I'm just a little paranoid about a real-time application having two programs trying to retrieve info from a Database every second!