If implemented correctly, performance hit could be minimum. Do what query if(records in selection([WhateverTable]>0) if(<>TeamAccessRequired)\\some customers do not need this feature Query selection with array([WhateverTable]Team;<>CurTeam) end if end if
<>CurTeam is loaded from team member table at startup method. Query selection with array is NOT preemptive in 4D 13/15 that might have performance hit on server. Based on v16 doc, this command would be preemptive and hopefully it does not have hidden limitation. Alan Chan 4D iNug Technical <4d_tech@lists.4d.com> writes: >That sounds like real DOD level stuff. Fortunately I don't need that level >but it gives me some ideas. > >What kind of performance hit did you see as a result of all that extra >processing? ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************