OraFAQ Forum: Forms » My form is working very slow

Home » Developer & Programmer » Forms » My form is working very slow (Oracle form, 11g, windows)

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

My form is working very slow [message #658447]

Wed, 14 December 2016 04:18

manisngpl
Messages: 42
Registered: December 2014
Location: Faisalabad, Pakistan

Member

My form is retrieving data very slow approx. upto 6 minutes to fetch the data in block. Please let me guide how can I debug my form.

Report message to a moderator

Re: My form is working very slow [message #658450 is a reply to message #658447]

Wed, 14 December 2016 14:59

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Take a query that populates data in a form. Run it in SQL*Plus (or any tool you use), gather some information (such as explain plan), check whether columns you use in WHERE clause are properly indexed, etc. Shortly, visit our Performance Tuning forum, read (and I really mean it: read) How to tune SQL or Identify Performance Problem and Bottleneck sticky topic; hopefully, you'll manage to do something in order to speed up data retrieval.

Report message to a moderator

Re: My form is working very slow [message #658471 is a reply to message #658450]

Thu, 15 December 2016 06:57

cookiemonster
Messages: 13960
Registered: September 2008
Location: Rainy Manchester

Senior Member

And if that query runs fine then you need to look at any code the form runs when retrieving data - post-query is the obvious one.

Report message to a moderator

Previous Topic:	Excell Report Genearation With Formula (merged by MC)
Next Topic:	problem with calling form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 13:08:54 CST 2024