topic Re: Insertbuff in SAS Programming

Insertbuff

shivagujjaru — Tue, 14 May 2019 10:07:59 GMT

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

Re: Insertbuff

ChrisNZ — Wed, 15 May 2019 00:21:02 GMT

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.

Re: Insertbuff

shivagujjaru — Wed, 15 May 2019 01:52:54 GMT

What about bulkload ?

Re: Insertbuff

Patrick — Wed, 15 May 2019 03:57:54 GMT

@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.