Re: forms question

In article <7n7t7k$4a5$1_at_nnrp1.deja.com>, <sasubram_at_cisco.com> wrote:
>I am having a small problem in my form. I don't know whether there is
>any solution or not for this.
>before I go any further, let me explain how my form works. it has two
>blocks 1.dummy_block(no base table) 2. main_block(base table is a view)
>in the dummy block I have a radio_button field which has two child.
>Based on the user's selection of radio button I have to query the
>main_block. for eg. if user chooses radio_button1 then query all records
>for export_id = 1(doing it by setting the block_property)
>
>It takes almost 45 seconds to bring back 10 to 15 records when the user
>changes the radio_buton.
>My project_leader wants me to query all the export_id together and then
>do the manipulation. I have a post_query in the main_block which selects
>the description.
>
>when I run this query in the sqlplus session, it doesn't take more than
>1/2 a second. we know it's network problem and that's why she is asking
>me to reduce the trafic by going to the db only once.

I don't think the 45-second response time has anything to do with your query in the form. Forms is just as fast as SQL Plus. I'll bet the select in the post-query trigger is doing a full table scan (10 to 15 times!!!). Try removing the post-query trigger and see what happens.

Steve Cosner Received on Sun Jul 25 1999 - 21:07:35 CEST