Difference between KNIME table and SQL SERVER

With greetings to dear friends
I have a heavy data that is more than 100 million rows and I want to store it and use it in my analysis when necessary.
My question is, is the data fetching speed faster in KNIME table or in SQL SERVER?
And which one is more secure for my data?

@alex1368 , your question is too broad. If all your data are in mentioned table then to store it locally could be beneficial. In case you assumes joins of the table to other one on SQL server it would be better to make joins in SQL server.
For better answer please describe specific scenarios.

1 Like