Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Performance Question
Message
From
26/01/2003 03:53:17
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00745420
Message ID:
00745501
Views:
16
This message has been marked as a message which has helped to the initial question of the thread.
Stored Procedures can be precompiled, so they should run a tad bit faster.

>I have a lot of queries that are built inside the vfp front end, very simple example here with how I call it:
>
>
>lcLastName='KELLY'
>text to lcCmd noshow
>    select lastname, firstname, mi from coPatients where isactive=1
>      where lastname=?lcLastName
>endtext
>
>if sqlexec(gnConnHandle,lcCmd,"CurPatLookUp")<1
>   =sqlerror()
>else
>   ...code here
>endif
>
>
>is there a performance difference if I make all my queries StoredProcedures vice just calling them in this fashion?
>
>Thanks
>Kirk
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Reply
Map
View

Click here to load this message in the networking platform