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 VB Studio.

1. Can VB Studio 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.

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.

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.