What is the recommended number of rows that can be loaded in a single batch?
For an initial load, you can use 30,000 rows for a large batch. For ongoing loads, you can use 20,000 rows for a large batch. You should not exceed 100,000 rows in a large batch.
Furthermore, you should limit the number of records in the interface tables to those that are being processed. For example, if you have determined that the optimal batch size for your system is 19,000 rows per patch and you are going to be running
8 parallel EIM processes, then you should have 152,000 rows in the interface table. Under no circumstances should you have more than 250,000 rows in any single interface table, since this will have a tremendous negative performance impact.
NOTE: The number of rows you can load in a single batch may vary depending on your physical machine setup. To reduce demands on system resources and improve performance, you should always try to use smaller batch sizes.
Related Articles:
Browse Categories
User login
Navigation
Popular content
- Autosys Job Handling (13,688)
- GE UNIVERSAL REMOTE INSTRUCTIONS (12,386)
- Siebel User properties (9,114)
- Test 1 - NC Drivers License Test - DMV Question Dump (8,811)
- Making a View "Read Only" based on a criteria: Aspect User Property (4,231)
- Siebel Application Response Measurement (SARM) (4,167)
- Siebel Predefined Queries (PDQ) – Reference (4,091)
- Siebel Server Component Event Logging (3,676)
- Strategies for Building Team Cohesion (3,163)
- How to create the EBC’s in Siebel (3,096)
Readers who viewed this page, also viewed:
- How To Add a New Property or Set the Value of an Existing Property in the Siebel Message XML that is Being Sent Out Through a Workflow Process (150.0%)
- Siebel Webservice And EAI - Basic Concepts ans Steps Involved (150.0%)
- How can I hide the superfluous message in the “VBC error pop-up window“ (150.0%)
- Web Portal Integration with Siebel Applications (150.0%)
- XML Tools And Utilities (150.0%)
- Siebel XML Web Interface (150.0%)
- How to define Siebel CRM specific service fields (Fault, Header) in .WSDL, generated for a Siebel Inbound Web Service? (100.0%)
- Philips SRU2103/27 Universal Remote control codes for TV, VCR, Set-top Box (100.0%)
- Server Tables Cleanup component failing - deadlock trying to delete records from s_srm_request (100.0%)
- Purging an EIM table (100.0%)
