Information générale
Forum:
Microsoft SQL Server
I want to learn more about SQL2K with VFP 7.0
I readed a book Client/Server App With VFP and SQL to see how I could improve performance
and get more control with my app's to move from VFP Tables to SQL Server 2K Databases.
Some questions:
1) In large Tables, whitch is the performance difference using SQL-Stored Procedures,
passing just the procedure's name + parameters using SQLEXEC(), from sending a query
Statement + parameters to a remote server using pass through.
(is the responce time difference here just the difference form the moment that SQL receives
the statement, analyses, seek permissions, etc.. till it starts to process the statement, like when calling an SP ?)
Should the responce time increase if the SQL Server Statement is more complex ? If yes how much more time it would take. ( just an idea of time increase )
2) It's better to use Remote views or Cursors, this questions is due, that I discovered
that I only can control Error messages sended by SQL using Stored Procedures (SP).
Remote views look very good, but in a one-to-many form, when I try to update or insert in the
"many records part" sending Tableupdate(), I dont see a way to get what record got an error from
the server, and so I could send a specific error message, is there a way to do it ?
3) I was thinking in develop in VFP something that could create "SQL-SP scripts" for Update,
Insert, Delete, getting the table structure of some table, generating the parameters with
the same name of the field starting with an 'p_' so each parameter it would look like '@p_field_name' at the beggining of an SP passed as a parameter.
Reason: Save time in writing SQL-SP.
Does exist some class/product that does this ?
Thanks in Advance
Peter
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement