topic Re: checking sort table as performance related one in Application Development and Automation Discussions

checking sort table as performance related one

Former Member — Fri, 13 Feb 2009 05:54:27 GMT

hi folks,

i am working on a report. in this im working on performance issues.

i want to check if sort table is used in the report.

i want to know the conditions where sort table IS A MUST to use for performance check purpose.

thanks in advance.

Re: checking sort table as performance related one

Former Member — Fri, 13 Feb 2009 06:00:54 GMT

Hi Michael

Sort table is recommended when you have to do READ TABLE BINARY SEARCH. You don't have to sort it in the code then.

Pushpraj

Re: checking sort table as performance related one

Former Member — Fri, 13 Feb 2009 06:05:40 GMT

Hi,

Don't use order by because it executes on database server, instead u collect them in a table and sort that table.

Regards,

jaya

Re: checking sort table as performance related one

Former Member — Fri, 13 Feb 2009 06:06:58 GMT

Hi Micheal,

You use use sort table while your using control break statements like at new or at end .

Much Regards,

Amuktha.

Re: checking sort table as performance related one

Former Member — Fri, 13 Feb 2009 06:27:12 GMT

Sort table is improve performance bcoz it has default sorting criteria. so no sorting again.

at the time of using Control Break statements. and it is use full for Binary Searching bcoz Sorting is Mandatory. And No append command is working on it.

Re: checking sort table as performance related one

Former Member — Wed, 25 Feb 2009 06:37:40 GMT

thanks alot