MB Software Solutions <> wrote:
> Hmmm....so if one were to have a VFP system whereby it created the
> UPDATE SQL for multiple updates along with possibly INSERTS for new
> records, one could daisy change them together in one fell swoop using
> a single SQLEXEC statement, if I read this right. Does that mean
> better performance since you're making fewer trips to the server or
> is this perhaps 6 of one, 1/2 dozen of another? Curious...(yeah I
> know...design some test code and try it....)
It depends on your connection quality. If you have your data server through
a lot of hops on the other side of the country or world you will defiantly
see an improvement for SQLNonQuery or SQLExecuteScaler.
If the data server is on site you may see a tiny benefit.
Stephen Russell
DBA / .Net Developer
Memphis TN 38115
901.246-0159
"A good way to judge people is by observing how they treat those who
can do them absolutely no good." ---Unknown
http://spaces.msn.com/members/srussell/
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.11.15/949 - Release Date: 8/12/2007
11:03 AM
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
