Performance: Autosearch criteria VS SQL WHERE clause

rbuser

Hi,

I'd like to know how fast are the AutoSearchField VS using a SQL WHERE
clause in Report Builder? I suppose that SQL WHERE clause is faster on a
huge amount of data, but I'm curious, because I have reports with complex
queries with a lot of INNER and LEFT OUTER joins. Any people did some tests
?

David Caouette

nicocizik

Hi David,

Using the AutoSearch feature in ReportBuilder is the exact same as changing
the Where clause in the sql. In fact, this is how AutoSearch works. See
the AutoSearch demo located in the \RBuilder\Demos\5. AutoSearch\3.
AutoSearch Field to SQL Where Clause\... directory to see how this works in
Delphi.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com