> >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's probably negligible unless there's tons of connections/users at the same time, but I've seen this technique used on several other apps I've assisted on (albeit connecting to SQL Server, rather than MySQL), so someone must think it helps.. :) _______________________________________________ Post Messages to: ProFox@leafe.com 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.