Hi Carey, Why would using non-phased filters make a difference when looping through the table? Not that I doubt you, just trying to understand the reason why.
As for performance, I've run a SQL/API combined and a Filter/API combined and run through the AR Log Analyzer. The only issue I can find as far as indexes go is the AR System Email Messages schema...the index on field ID 1 is not being used there for some reason. I'm going to have the DBA delete and recreate it since I have no access to the database system. I realize that with this new notification system, I'm asking the system to do a lot more processing and that will naturally take some time...20 filters being run for each record in a table...for groups with 10 or more members, that's at least 200 times those filters are run...this is why I am pushing fields to a separate form and running the filters there, but the filter logs show this processing before all the normal HPD filters have finished. Perhaps if I changed the execution order and made the notification filters on HPD fire last? Thanks for the help, Kevin R. Carmack _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
