On 12/14/12 8:40 AM, M Jarvis wrote: > On Fri, Dec 14, 2012 at 8:02 AM, MB Software Solutions, LLC > <[email protected]> wrote: >> > On 12/13/2012 9:23 PM, Paul McNett wrote: >>> >> >> > Chuck Urweiler (Hentzenwerke author) at a meeting and he swore that there >> > was no difference between RVs and SPT. > Perhaps in performance, but I vaguely recall Doug Hennig saying at > Devcon once that the problem w/ Remote Views was scalability... > > Maybe my memory is fuzzy...
My memory is fuzzy, but if I recall I had a problem with the compiled code for the view in the DBC. When user 2 went to requery with a certain set of parameters, the view would need to be recompiled, which it couldn't do because of user 1 with their unique set of parameters to the same query. I believe I worked around that by making local dbc's (stored on each user's system) but then the problem would resurface if the same user wanted to make different parameterized queries to the same remote view. Switching to SPT simplified all this immensely, and I had a period of hitting myself for listening to consensus. Paul _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.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.
