Post reply

optiontips.in

  • October 23, 2011 at 9:09 pm

    #390679

    Hi All,

    My requirement is, based on the input selection from the frontend we have to query the database and then display the records based on the input. Sometimes we may have to display all the records from database. So I am using a DB Adapter in a SOA Composite and using Select operation. we have SQL query written in that Select operation. Initially the service was working fine because the number of records were very few. So it was fetching the records from the table and then we are able to display in the UI as well. Now the problem is we have more number of records in that table (more than 10000). So SOA Composite takes a lot of time to execute. Thats why we couldnt display all these records in our frontend. Can anyone help on this.

    Thanks,

    optiontips.in

  • October 27, 2011 at 11:29 am

    #1400312

    optiontips.in (10/23/2011)

    My requirement is, based on the input selection from the frontend we have to query the database and then display the records based on the input. Sometimes we may have to display all the records from database. So I am using a DB Adapter in a SOA Composite and using Select operation. we have SQL query written in that Select operation. Initially the service was working fine because the number of records were very few. So it was fetching the records from the table and then we are able to display in the UI as well. Now the problem is we have more number of records in that table (more than 10000). So SOA Composite takes a lot of time to execute. Thats why we couldnt display all these records in our frontend. Can anyone help on this.

    A ten thousand lines report makes no sense - no business person has the ability, time and focus to look into such a huge volume of data.

    Having said that - how about performance tunning your query? Do you have a trace showing where time is spent or wasted during execution?

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply