Subject | Re: [Firebird-Architect] RFC: Cross database queries |
---|---|
Author | Vlad Horsun |
Post date | 2007-08-02T14:04:17Z |
> I agree with this. The purpose for which we need this feature is to be able to split our PointThen, i'd said, you need tablespaces with ability to be backed up separately.
> of Sale system databases between the configuration information (and the most recent few days of
> collected data), and the "historical" collected data. Our system has over 200 tables, only about
> 20 of which store sales, timeclock data, security logs, etc. The configuration information plus
> the last few days of (not yet locked) sales data would rarely exceed 100MB, even in a 20GB
> database containing 5 years of sales data for 30 locations. If we can divide this, we can do
> much more frequent backups of the "dynamic" data, and still be able to query the historical data
> for reporting. But we need to be able to join the collected data to the configuration in order
> to do complex where clauses.
But this is another story ;)
Regards,
Vlad