> 1 million transaction a day means less than 20 transaction per second.
Yes, if the transactions where evenly throughout the day -- over a 10-12 hour work day, we are talking about 40-50 transactions per second. > 200 GB on SSD storage is a matter of minutes to be copied. It depends on the SSD but 10-15 minutes. > Are you sure that nbackup won't do what you want? I need to extract the data and generate text file -- but I don't need all of rows. > PS: I would suggest replication. Your 20 tps is low-load. When you are trying to coordinate processes it is a large number!!! ------------------------------------------------------------------------------ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
