Questions And Answers for PowerBuilder Interviews

Question

Explain how 'Retrieve Only Needed' works.

Click here to see the answer

Answer

By default, PowerBuilder displays the first row on the screen when it completes retrieving all the result set. That means, if there is huge result set, user has to wait for long time to see the first row on the screen. If you turn on 'RetrieveOnlyAsNeeded' property, PowerBuilder retrieves only those rows that fit on one screen. That means, user will see the data quickly. When the user scrolls, PowerBuilder retrieves again (as many rows as required). This option might affect the database server performance also, since the result is queued at the database till PowerBuilder client completes retrieving.

Click here to go to top of the page.

Home	Previous Lesson: Question: #57 of #131 Next Lesson: Question: #59 of #131