Patrick Russell (11/7/2008)

---

I have some procedures which i consider simple (joining 5 tables) returning mayby 10-12 records/with 3 columns. When I run the app, and it accesses this particular procedure it takes about 8 - 10 seconds to return the data. Testing, I ran the same procedure in the SQL Analyzer and it also took about 8 -10 seconds. I then ran it using the select statement in the procedure and it returned in less then a second. To confirm, I gave the db user select rights to the tables in question then changed the app to pass a select string instead of a stored procedure and again it returned in less then a second.