-4

I'm having two loans table. one is for internal other one is for external. Both having similar columns.

I don't want to disturb one for other so i have created 2.

Problem is both has to be sync. Currently i'm using api calls to update from one system to other. I want to use trigger.

But i dont know wheather trigger will affect performance or not.

About my table my external table is having more than 25 columns, data i'm having more than 30k rows.

Update will be like they will update one column at one row that should be reflected in internal table.

In this case trigger is usefull or will give performance issue?

Improve this question
1
  • 1
    You are the only one that can probably answer that question. No one else has access to your servers, databases, schemas, indexes, data and applications. Try building a prototype and benchmarking the alternatives. Commented Nov 13 at 14:03
Related questions
7612
Why is subtracting these two epoch-milli Times (in year 1927) giving a strange result?
1603
How can I concatenate two arrays in Java?
210
Insert Update trigger how to determine if insert or update
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.