>This test was returning 1 record from a 47,000 record table based on the KeyID. My times were 0.05 seconds for SPT and 0.09 seconds via the package.
Yeah, if even the way with more overhead were still less than 1/10 of a second, I'd probably be fine going this way. I'll do more testing with my server and data, but so far it appears my SP overhead is quite a bit more than what you are seeing (more like .1 or less for SPT vs. .25 to .5 or more for SP).
For one execution, even that is not a huge deal, but if a form needs to run 5-10 queries to get related data, the difference would magnify into a big deal.
Thanks,
Kelly
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only