3 ms·
With stored procedures you run your code inside of the SQL server process. With SQLite, your entire application IS the process, and your SQLite data moves from
by justsomeuser 5y ago
With stored procedures you run your code inside of the SQL server process.
With SQLite, your entire application IS the process, and your SQLite data moves from disk to your app processes RAM.
I think the SQLite model is much better as you get to use your modern language and tooling (which is better than the language used for stored procedures which has not changed in 20 years, and is generally a bear to observe, test, develop).