Performance: Using interprocess, intraprocess, row buffers
Posted: Thu Feb 14, 2008 4:18 pm
Though I've been using DS for about five years, I've had no previous need to change the default performance settings for any of our ETL. Recently, though, I've begun exploring what is available and have read lots of threads about these three topics on DSXchange.
But a question remains unanswered: Based upon reading the manuals, it seems I would want to use the "Enable row buffer" option by default because it may generally improve performance. However, it is disabled by default so that implies there is some kind of trade-off or that it should only be used under specific circumstances -- something like that.
Are there reasons one would not use the "Enable row buffer" option? One consideration (I think) is when you have rows of sufficient length to exceed the row buffer? Are there cases where using the option would be a hindrance?
I plan on testing these options best I can but thought someone here might be able to weigh in with some experience.
![Smile :)](./images/smilies/icon_smile.gif)
But a question remains unanswered: Based upon reading the manuals, it seems I would want to use the "Enable row buffer" option by default because it may generally improve performance. However, it is disabled by default so that implies there is some kind of trade-off or that it should only be used under specific circumstances -- something like that.
Are there reasons one would not use the "Enable row buffer" option? One consideration (I think) is when you have rows of sufficient length to exceed the row buffer? Are there cases where using the option would be a hindrance?
I plan on testing these options best I can but thought someone here might be able to weigh in with some experience.