Let's say we have a typical Access application setup - Access front end on PCs and back end on a network file server. Assume the app has 100 queries used on various forms (as the form recordset, for listboxes, combos etc). Queries are also used as recordsets for reports.
When migrating an Access backend to SQL Server the recommendation is to migrate queries too (where possible). I appreciate there may be performance gains in doing so, but are there actually any performance issues with not migrating queries? Without migrating queries would performance be any worse than with the original Access backend?
When migrating an Access backend to SQL Server the recommendation is to migrate queries too (where possible). I appreciate there may be performance gains in doing so, but are there actually any performance issues with not migrating queries? Without migrating queries would performance be any worse than with the original Access backend?