General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Stored Procedure Good/Bad? How?
Hi All,
I am trying to increase the performance our programs. At the present we do all processing on the client side. I have heard that it is better to do this on the server side. This I assume means STORED PROCEDURES. Question, are they faster for SQL statements. The following works:
nconhandle = sqlexec(nhandle, mysqlstatement, 'mycursor')
From here I can use the cursor I retrieved. What I would like, is to have the statement on the server in a stored procedure. If that is the way to go for this kind of data retrieval. What I don’t know is how to call that procedure and return the cursor.
We are using VFP6 SP3 with a standard VFP database.
Any & all thoughts are welcome.
TIA
Mike
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