in our application , there is only one sqlserver database in used.
when customer view a report page ,it need run many sql query and cause system became slow.
to avoid this problem ,we try to duplicate data to another sqlserver database ,and try to run query in that database.
so, the question is how can i design this function , in normal usage, use the same database both curd operation and report query ,in heavy data environment , query data from another database.
i know nettiers can config 2 database section , but it seems to be fit 2 assembly , how can i config 2 database section and use in one assembly ?
thanks!