My Oracle Support Banner

MRI - VBCS - What Is The Maximum Data Limit That Business Objects Hold (Doc ID 2556924.1)

Last updated on NOVEMBER 30, 2019

Applies to:

Visual Builder - Version 19.1.3 to 19.1.3
Information in this document applies to any platform.

Goal

Qn1:Currently we are having a requirement that we will receive some source files which will have data of about 220K to 250K. We need this data to be loaded to VBCS business objects to fulfill some of the requirements.

We knew that there is a limit with Business Objects storage space and the maximum limit is of 5GB. Considering this we are looking for clarifications for the below mentioned points.

1. Will VBCS business objects can hold data of about 220K to 250K
2. If Business objects hold data of about 250K then do we have any performance challenges to access this data.
3. By using Business Objects REST API (PUT/POST) operation, can we load data of about 250K in one single load.
4. Once the 250K of data is loaded by using some business logic it will get updated with some default values and the latest data needs to be extracted back. As part of that if we use business object GET operation will it retrieve this entire load or what would be the ideally way to extract this 250K.


Qn2:1. Will VBCS business objects can hold data of about 220K to 250K
2. If Business objects hold data of about 250K then do we have any performance challenges to access this data.
3. By using Business Objects REST API (PUT/POST) operation, can we load data of about 250K in one single load.
4. Once the 250K of data is loaded by using some business logic it will get updated with some default values and the latest data needs to be extracted back. As part of that if we use business object GET operation will it retrieve this entire load or what would be the ideally way to extract this 250K.
5. What is the maximum volume that individual Business Objects can hold. Considering that the individual business object has around of ten columns. What would Oracle Suggest to limit the max volume in business object to handle?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.