Home » Developer & Programmer » Forms » forms running very slowly. (Oracle 10g, Database 9i, Windows XP)
forms running very slowly. [message #314171] Tue, 15 April 2008 23:04 Go to next message
Messages: 59
Registered: March 2008
I am running a form from my Pc connecting to scott/tiger.
Now when I execute a query (when new form instance) , it takes a very very loooong time .
However all the other forms are running fine with no such delay.
Even this form was working fine until day before yesterday .

I even tried querying /updating/commiting the database to see if some transaction in pending.But even that is not the case.

Please help me get this going faster... URGENT Please ..
Re: forms running very slowly. [message #314175 is a reply to message #314171] Tue, 15 April 2008 23:35 Go to previous message
Messages: 59
Registered: March 2008
I fixed it.
I had a detail block and I had createda relationship.Removing it made it work.However do nto know why it took time even if master-details relationship is there.
Here I am not displaying any field from the detail block on the form.
I have worked on other forms also where we have mroe than 1 relation and it dnt take so much time.
Experts can give better answers..
Previous Topic: Calling a report from a form
Next Topic: Pls Required Answer...
Goto Forum:

Current Time: Thu Aug 17 14:29:06 CDT 2017

Total time taken to generate the page: 0.10587 seconds