02.04.2014 0:59, Leyne, Sean wrote: > Consider a large database (200GB, large tables with 450 Million rows) which > is running on a kick-a** server with pool of enterprise SSDs for storage > (more IOPS then Firebird could ever use), which I need to extract data from > on a regular basis throughout the day for use by an external BI system. > During the business day, the database is Live with over 300 connections > active with 1 million+ DB transactions. > > I need to extract the BI data as a true "snapshot" of data (ensuring FKs are > valid), in as short a timeframe as possible.
1 million transaction a day means less than 20 transaction per second. 200 GB on SSD storage is a matter of minutes to be copied. Are you sure that nbackup won't do what you want? PS: I would suggest replication. Your 20 tps is low-load. -- WBR, SD. ------------------------------------------------------------------------------ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
