Re: shared (database) file and multiple users
- Posted by ChrisB. Jul 03, 2008
- 731 views
Hi
Index table is a good idea because it would be, and remain small. Its not much different to a poll file, but perhaps a bit more robust.
Using the client server model still doesn't remove the requirement for polling.
I think that what Eik wants is for the server (where the database is held), to send all the clients a signal that there is new data. Unfortunately, the clients are still going to have to have a program running (in the background) that listens for this signal - effectively polling I'm, afraid. Theres no way round it. You're going to have to have programs running on the clients that listen for signal. You could use that sockets library, and have a little program running on the server that sends info to the client sockets programs, this would avoid the need for writing to a specific file, or database table.
The little program on the server would still have to check for changes every few seconds or so. So you would still have to monitor the database in some way.
As with anything, there are probably a ton of different ways to do this, none wrong or right.
Chris
