Liveware Publishing Support Forum

We are building an app that builds text control files, then runs it much the same way the icon builder generates .RSS files. In RRSQL v.12 we have found that a "built" filter in a text control file causes a significant slowdown over just having a "?" in the filter and having the user build the filter using the dialog box. The customization our users and managers want seems to come with a huge performance hit. Are we doing something wrong?

An RI_FILTER expression gets evaluated locally rather than being passed to the server.____You should alternatively use RI_WHERE since it is passed directly to the server as part of the WHERE clause.____Regards,__Kathleen__R&R Support

Good solution. Thanks for the help.