firebird-support - Modify database structure, add and drop indexes while in heavy use?

Subject	Modify database structure, add and drop indexes while in heavy use?
Author	Caroline Beltran
Post date	2015-12-15T15:32:53Z

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.