I have about 1500 Dynamic Send ports and now it is almost impossible to use Administration Console because of its performance. It takes just 10 minutes to refresh application or 1 hour to delete a Dynamic port or Application.
We have noticed that there are enormous amount of query on bts_dynamic_Sendport_handlers table and this cause problem. Whenever I try to do anything , foreach sendport it makes a query on this table and as there is 30.000 records here, it takes too long time because same query works 1500 times at least.