I have a FB database 4 tables. I decided to add some columns, drop one index and create two indexes while the FB database handling a 12 hour long batch job.
Between all tables, these batch jobs consist of an average of 1 to 20 INSERTS per second and 10 to 40 UPDATES per second. There are also approximately 5 selects (with JOINS) per second. To avoid the expense of opening and closing connections, I am running a connection pool with 15 shared connections. I don't want to bog this message down with excessive details and would like to know if performing modifications to the database running such a batch is a bad idea. Thank you for your time. I am using Firebird 2.5.4 Superserver on Windows 2012 64 bit.