chandresh.hingu

 Profile Answers by chandresh.hingu 

• Dec 28th, 2007

 

The use of Memory sorter is ,
in report you can sort the data in 2 ways
either you sort in tools level using property SORT or else samething you can do at actuate report level using data memory sorter.

Please let me know if you need more detail

ffpradella

 Profile Answers by ffpradella 

• Mar 25th, 2009

 

The MemoryDataSorter component provided in the sscustom.rol library file is used in a Siebel-Actuate report in order to perform sorting on rows. It does this by reading and storing the data rows in memory, which are then sorted.

Since MemoryDataSorter stores all the records in memory and then sorts them, when the report is run against a large set of records, this could affect the performance of the report.

Report objects in Siebel Tools can have a sort specification specified. However, this may cause the database to take longer to return the records in the order required. In these cases it may be better to have the report sort the returned data itself.

Oracle documentation recommends approach to sort records in a report is to specify the sort specification on the report object definition in Siebel Tools.

My personal suggestion is to perform tests using both and check what better fits your requirements.

Hope it helps.

Fernanda