Home » Developer & Programmer » Forms » My form is working very slow (Oracle form, 11g, windows)
My form is working very slow [message #658447] Wed, 14 December 2016 04:18 Go to next message
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.
Re: My form is working very slow [message #658450 is a reply to message #658447] Wed, 14 December 2016 14:59 Go to previous messageGo to next message
Littlefoot
Messages: 21549
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.
Re: My form is working very slow [message #658471 is a reply to message #658450] Thu, 15 December 2016 06:57 Go to previous message
cookiemonster
Messages: 13864
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.
Previous Topic: Excell Report Genearation With Formula (merged by MC)
Next Topic: problem with calling form
Goto Forum:
  


Current Time: Sun Apr 05 22:13:07 CDT 2020