01-07-2011 01:05 PM
04-24-2018 10:21 AM
do you know if there's a way to calculate in a prior way the optime buffersize?
can you help me?
thank you very much
04-24-2018 10:34 AM
If I'm not mistaken, READBUFF & BUFFSIZE (SQL PASS Through Option) are related to the -MEMSIZE option allocated to your SAS session, right?
If you increase these options READBUFF & BUFFSIZE, without increasing the -MEMSIZE then you are likely to see decremented performance, after all, these options affect he amount of records you are placing in memory in every fetch operation from the database.
It's no difference in concept when dealing with sorting large data set or even summarizing a data set, having the optimum -memsize & -sortsize option values affect your SAS performance.
Just my 2 cents,