Insertbuff

[shivagujjaru]

What is the max insertbuff I can submit
In general I use insertbuff=10000

[ChrisNZ]

1. This option is DBMS-specific

2. This option interacts with other options such as INSERT_SQL and DBCOMMIT.

3. More doesn't always mean better.

From the documentation: The optimal value for this option varies with factors such as network type and available memory. You might need to experiment with different values to determine the best value for your site.

You should test to see what gives the best results for your data in your environment.

[shivagujjaru]

What about bulkload ?

[Patrick]

---

@shivagujjaru wrote:
What about bulkload ?

---

Same story - it depends. 

For example with Oracle the intermediary text file created is rectangular with all SAS character columns fully expanded (=all the trailing blanks written to the intermediary text file). If you've got character variables with a big length which are mostly blank then using bulk load is likely not your best option.