Unanswered: Proxy table performance in the SAME DBMS instance
In our application, the PROXY TABLE is error used. The proxy tables are connected to tables of another database in the same service. And these tables are visited very frequencely. The two-phase commit of the service is not configurated.
Now, I have notiiced that ASE process ( sqlserver.exe ) often takes 50% of CPU, and the LOG of master is always fulled soon. And the application runs slowly while accessing these tables.
Can anyone tell me how much will this usage reduce the performance according to use VIEW?