Execution time difference for a function in two schemas

76 views Asked by At

We have a fabrication database hosted on three instances. On instance 1 and instance 2 it is called FabDB and on instance 3 it is called CRDB.

In general it makes no difference in the data being retrieved using CRDB or FabDB for any table. I think the tables data is stored at a common place.

We wrote a function in one of the schemas of fabdb. We have granted all permissions and synonyms.

If we run the function from FabDb it completes in 3 seconds. But if we run it from CRDB it takes 580 seconds. I am not sure where this is going wrong.

0

There are 0 answers