Hi Michael,
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
MC
Hi Michael,
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,
Ahmed
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.