On 4/3/2014 11:19 AM, Dimitry Sibiryakov wrote: > 03.04.2014 17:08, Jim Starkey wrote: >> Sean has done an exemplary job of explaining his abstract problem >> (capturing a consistent snapshot of a subset of data), the constraints >> (gotta be fast), and a proposed solution (parallel threads/processes >> with cloned transactions). > In this case I once again have to suggest to use replication to separate > database which > is used for BI or export. > This target database will always have consistent snapshot of a subset of > data. > Replication work with changes only that's why it is fast. And the main > advantage: it > can be used right now, there is no need to wait for custom Firebird build. >
But don't you have exactly the same problems on the replica unless you take it off line? And if you take it off line, it has to be re-synched. I'd go for a clean architectural solution over an operational nightmare every time. ------------------------------------------------------------------------------ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
