Filters in file run slow in RRSQL

[AAVasaris]

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?

[kfleming]

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

[AAVasaris]

Good solution. Thanks for the help.