OraFAQ Forum: Forms » Tuning view

Home » Developer & Programmer » Forms » Tuning view (Forms 6i, Oracle 10g, Windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Tuning view [message #574981]

Thu, 17 January 2013 05:55

mvmkandan
Messages: 68
Registered: May 2010
Location: Trivendrum

Member

Hi Experts,

I have created a View in Oracle DB and I designed one form in Oracle D2k. In that form, i have 3 data block. All are to be populated from the same view based on filertaion given in where condition.

I need to filter the grid (three blocks), based on the param selected on that form.

I executed the view in DB,it took just 350 milliseconds only. But I put more where conditions for the parameter sected. So it get very slow.. it took near about 3 minute to load the data in screen.

My Where conditions psedeo Code is in datablock is

SourceTable = 'Block1'
And Col1 = NVL(:header.param1, Col1)
And Col2 = NVL(:header.param2, Col2)
And Col3 = NVL(:header.param3, Col3)
And Col4 = NVL(:header.param4, Col4)
And Col5 = NVL(:header.param5, Col5)
And Col6 = NVL(:header.param6, Col6)

Like this i wrote the code in each data block where field.

Could you please any one give your suggession to speed up this.

Thanks

Veera

Report message to a moderator