@nba please keep in mind that the performance of an SQL database will also depend on the power of the machine it is running on.
In general it will make sense to employ a database system and use KNIME as your platform.
You could also try to improve the performance of your KNIME workflows:
About KNIME and SQL I can offer this collection which also links to an SQL Introduction and this sample workflow.