search

steffengy / tiberius

TDS 7.4 (mssql / Microsoft SQL Server) async driver for rust. Fork at: https://github.com/prisma/tiberius
Apache License 2.0
151 stars 2 forks source link

Prefer sp_executesql over sp_prepare #83

Open peschkaj opened 5 years ago

peschkaj commented 5 years ago

sp_prepare suffers from some poor optimization issues in SQL Server. Modern apps should be using sp_execute.

brokenthorn commented 5 years ago

Might have needed a reference to advocate this. Here's the issue being addressed by Microsoft.