Paramaterized Queries
Database
1
Posts
1
Posters
0
Views
1
Watching
-
I've written an app using ODBC.NET in c# using paramaterized queries. Taking timings for these queries to run gives me larger times than issuing ad-hoc SQL statements to the database. This isn't what I'd expect to see as I thought the database would cache my queries and then be able to execute them faster. I've tried this on Oracle and SQL Server and seen the same results. Has anyone else seen any similar results, i.e. paramaterized queries taking longer to execute than ad-hoc SQL? or is it just me:confused:? Ta, Dave.