What Is The Maximum Data Limit for Business Objects?

Refer to these frequently asked questions and answers for help retrieving and posting large volumes of data to and from Visual Builder.

1. Can Visual Builder business objects (BO) hold 220K to 250K records?

   Yes, they can hold that number of records.

2. Are there performance challenges in accessing data from BOs of this size?

   Depends on what performance you are hoping to achieve. A query on a table with that number of records will, of course, be slower than a query on a table with fewer records. This may still be fast enough for your needs. The way to verify it is to test the performance with your specific data and scenario.

3. Can I load data of about 250K in one single load using REST API PUT/POST operations?

   You can use the batch approach to load this much data. However, you might also want to look into loading the data directly using the data import APIs. See Import Data from the Command Line.

4. Can I retrieve data of this size using the GET operation? Is there a better way to extract 250K of data?

   Get operations will get you the latest data from your BO. If you need to export all the data to another system, consider using the data export APIs. See Export Data from the Command Line.

5. What is the maximum volume that individual BOs can hold, given a size of ten columns? What would Oracle suggest to limit the maximum volume in a business object?

   This depends on the amount of data in each column. The database is limited to 5GB so the calculation would be something like 5GB/the amount of data in a row.