VB.Net live data to database
Hey,
How would I go about making a live data stream to my database?
What I mean is something that keeps view on the database to monitor any changes immediately.
Im using VB.Net with MySQL server on an external database.
I know about doing the connections and commands, and parts of data reader.
Cheers,
Jessee
How would I go about making a live data stream to my database?
What I mean is something that keeps view on the database to monitor any changes immediately.
Im using VB.Net with MySQL server on an external database.
I know about doing the connections and commands, and parts of data reader.
Cheers,
Jessee
Dirk Haest
See comment at http://stackoverflow.com/questions/342031/net-sql-server-database-monitoring-insert-update-delete
Hi,
There can be many ways, but two of then are:
1. Store the Stream on File in file system. And Add a entry in database to that path.
2. Store the Stream on temp File in file system. And when stream is completed save the file in database and delete the temp file.
Thanks
There can be many ways, but two of then are:
1. Store the Stream on File in file system. And Add a entry in database to that path.
2. Store the Stream on temp File in file system. And when stream is completed save the file in database and delete the temp file.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Alternatively, you could store a set of references to the notes which have yet to be read on a per-user-profile basis, and then remove them when they're displayed (general use case is probably read all notes at once). This way you only have a tiny query when you pull an individual user, and your cost is in the insertion time for the global message, rather than filtering a big unread message table.