afternoon all,
we have a tiny db (about 3mb) that is comprised of 3 tables.
daily we delete the records out of 2 of the tables and reload new data.
when this is done the bi file grows quite large (as in more than 2 times the size of the db)
previously the tables were in another db and we did not see this bi file growth.
i reworked the programs that delete and add the records to the tables limiting the transaction scope and adding pauses. this limits the bi file growth (but i still think there should be none) but increases the time that it takes for the script to run.
i also find it odd that if i run the programs manually they take just over i minute to run, but when in a script it takes 7 to 9 minutes. although, bi growth is smaller when run from a script.
any ideas or suggestions?
thanks.
regards,
longhair
we have a tiny db (about 3mb) that is comprised of 3 tables.
daily we delete the records out of 2 of the tables and reload new data.
when this is done the bi file grows quite large (as in more than 2 times the size of the db)
previously the tables were in another db and we did not see this bi file growth.
i reworked the programs that delete and add the records to the tables limiting the transaction scope and adding pauses. this limits the bi file growth (but i still think there should be none) but increases the time that it takes for the script to run.
i also find it odd that if i run the programs manually they take just over i minute to run, but when in a script it takes 7 to 9 minutes. although, bi growth is smaller when run from a script.
any ideas or suggestions?
thanks.
regards,
longhair