clarencen/lshift — Issue #33: Investigate DB aggregation
Author: clarencen
Created: 2011-11-14 22:41:27+00:00
State: open

The streaming based approach to aggregating unmatched events may be expensive in terms of network bandwidth and the parsing and aggregation operations that need to occur in the application. Initial profiling shows that this operation might be quite costly. An alternative approach would be to perform the same operation in the DB. This brings along a number of considerations:

* The DB code would not be very portable, hence we would need to limit the databases that we support, or fall back to the stream based approach for non-supported databases;
* DB Procedures code is quite different across DBs;
* Should we keep maintaining the current stream version to act as test framework?