Bug 125 - SQL 'subscriptions'
Summary: SQL 'subscriptions'
Status: ASSIGNED
Alias: None
Product: Varia
Classification: Unclassified
Component: Flow (show other bugs)
Version: unspecified
Hardware: PC Linux
: P1 normal
Assignee: Werner Van Belle
URL:
Depends on:
Blocks:
 
Reported: 2007-11-01 09:58 CET by Werner Van Belle
Modified: 2007-11-01 10:01 CET (History)
0 users

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Werner Van Belle 2007-11-01 09:58:00 CET
One of the problems often encountered is thqt a value might change and that we are only interested to execute the commands immediatelly related to that change. A good solution to this type of problem seemed to be able to be notified of 'data packet' changes. Such a data packet (token) would be an SQL statement that takes input from different places and would place its output into some form of command. When the original data changes this command would be reexecuted.

The problem with this at the moment is that it still means that we need to execute all potential queries and that in order to cache the data we get nowhere without comparing the necessary data that goes into the program. So:
- the cache needs to know exactly what will go into the program
- the notifier needs to execute all queries anyway.