Home » Developer & Programmer » Forms » Tuning view (Forms 6i, Oracle 10g, Windows XP)
Tuning view [message #574981] Thu, 17 January 2013 05:55 Go to next message
mvmkandan
Messages: 67
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





Re: Tuning view [message #575402 is a reply to message #574981] Tue, 22 January 2013 23:06 Go to previous messageGo to next message
mvmkandan
Messages: 67
Registered: May 2010
Location: Trivendrum
Member
I have solved this one.

Thanks
Veera
Re: Tuning view [message #575507 is a reply to message #575402] Wed, 23 January 2013 13:23 Go to previous message
joy_division
Messages: 4559
Registered: February 2005
Location: East Coast USA
Senior Member
Please share the solution otherwise this posting is as good as unresolved.
Previous Topic: Password field
Next Topic: Runtime deployment error while deploying - java.lang.OutOfMemoryError
Goto Forum:
  


Current Time: Sun Dec 21 20:48:27 CST 2014

Total time taken to generate the page: 0.09581 seconds