A year ago I wrote 3 LRs for the SOV to report some parameters(Port numbers, settings, etc.).
The data is in the DTREE.EXTENDEDDATA. I parsed it out in Oracle with REGEXP and some string functions. The Partition(Subtype=371) and Index engine(subtype=368) LRs would report in a couple of seconds regardless of whether there were 170 or 5 Partitions/Index Engines.
But the Search Engines(subtype=369) runs for a few minutes on an Oracle system that had nearly 200 Partitions and 20 minutes on a SQL Server system that had 5 partitions. In either case, if the LR is only reading these single records and parsing the same column, why does the Search Engine LR take so-o-o-o long? it parses out no more data and reads no more records than the other two. It utilizes no other Functions.
Curiouser and curiouser.
Riddle me this.
