Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Stored Procedure vs. ISQL

Status
Not open for further replies.
DecodeThis

DecodeThis

MIS
Joined
Mar 22, 2004
Messages
7
Location
US
Can someone please shed some light on this matter for me? Let me first say that I am a network engineer not a DBA. When I run a SP on one MS SQL server that accesses another SQL server the entire process takes about 14 seconds. If I run the same procedure in a query it takes 1 second. The developer is trying to blame the network. I believe it is the SP. Any suggestions would be great.
 
Sort by date Sort by votes
You may want to ask this in a SQL Server forum... this forum is primarily about VFP accessing DB's.

There may be people here, though with experience with this, though.
 
Upvote 0 Downvote
Oops! Clicked the wrong forum. Thanks for the heads up.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dylim
  • Locked
  • Question Question
Variables: NULL vs RELEASE
Replies
6
Views
817
tomk3
tomk3
T
  • Locked
  • Question Question
long vs short filenames
2
Replies
20
Views
3K
Joe Crescenzi
Joe Crescenzi
Steve Yu
  • Locked
  • Question Question
Data encryption at rest, VFP vs MS SQL
Replies
8
Views
1K
Chris Miller
Chris Miller
AlastairP
  • Locked
  • Question Question
CHAR vs VARCHAR - no real difference size on disk
Replies
4
Views
713
AlastairP
AlastairP
SitesMasstec
  • Locked
  • Question Question
Rerun Init procedure in a Form
Replies
14
Views
988
ggreen61
ggreen61

Part and Inventory Search

Sponsor

Back
Top