|Subject||Modify database structure, add and drop indexes while in heavy use?|
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.
To avoid the expense of opening and closing connections, I am running a connection pool with 15 shared connections.
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.
I am using Firebird 2.5.4 Superserver on Windows 2012 64 bit.