topic Re: Data Management : SQL Query Node vs. Data Validation Node in SAS Academy for Data Science

Data Management : SQL Query Node vs. Data Validation Node

Khokhaz — Tue, 04 Dec 2018 10:54:36 GMT

Which is better in terms of performance when filtering data rows Data Validation node or SQL Query Node ?

Re: Data Management : SQL Query Node vs. Data Validation Node

VDD — Tue, 04 Dec 2018 12:04:45 GMT

that depends on you validation needs.

https://communities.sas.com/t5/SAS-Communities-Library/How-to-calculate-cross-validation-error-using-the-Start-and-End/ta-p/307249

Re: Data Management : SQL Query Node vs. Data Validation Node

Khokhaz — Tue, 04 Dec 2018 12:07:40 GMT

I forgot to mention i meant in the Data Flux Application during Data preparation do i Use the Data validation node or SQL Query node for better performance.

Re: Data Management : SQL Query Node vs. Data Validation Node

Cynthia_sas — Tue, 04 Dec 2018 16:39:00 GMT

Hi:
This is one of those "it depends" questions. There's no right answer. You have to benchmark with YOUR data and YOUR servers and YOUR installation to see which one is better in terms of performance. We talk about benchmarking in our Programming 3 class and the trade-offs in tuning for I/O, for time or for ease of maintenance.
Cynthia