You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Query on data storage/performance

edited Aug 3, 2023 8:45AM in Autonomous Database 8 comments

Summary:

Due to excess data (5M records) causing performance issues and a heavy load on the application, we have decided to migrate the aged data to the Oracle database. The plan is to move 3M records to DB and then access these records from a 3rd party application same way as we accessing the data now.

We have OIC as middleware.

Content (required):

On implementing the above solution, will there be any performance issue from the DB when we try to read data from the DB from the 3rd party application?

I may store the data in separate tables (2001 to 2005, 2005 to 2010, and so on) or all in one table.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!