Home » RDBMS Server » Performance Tuning » forms 6i too slow when database have approximately 1 million records (Oracle 8i)
forms 6i too slow when database have approximately 1 million records [message #600618] Sat, 09 November 2013 08:13 Go to next message
qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN
Senior Member
forms 6i too slow when database have approximately 1 million records

Regards

Re: forms 6i too slow when database have approximately 1 million records [message #600621 is a reply to message #600618] Sat, 09 November 2013 08:21 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
"Forms 6i" is a tool. I presume you used it to develop your own form.

"Database has 1 million records". Do you mean "database" or a "table" (you, presumably, based your form on)?

I'd say that you created a form on a top of a table that contains 1 million records. Is that correct? If so, what operations do you perform with that form? Query? I hope you don't expect someone to browse 1 million records at the time - it means that you need to restrict number of fetched records with a WHERE clause (i.e. enter query, enter search criteria, execute query; raise an error if someone tries to fetch ALL records). Also, have a look at data block's "Query array sihe" and "Number of records buffered" (these are described in Forms' Help); set them to values different from default and run the form again in order to test its execution.

If I was wrong, maybe you should explain what exactly you are doing. One-statement-question is rather poor in this case.
Re: forms 6i too slow when database have approximately 1 million records [message #600692 is a reply to message #600621] Mon, 11 November 2013 05:17 Go to previous messageGo to next message
qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN
Senior Member
Yes Table has more than one million records when i am going to save new records it takes much time how to reduce it on key commit
Re: forms 6i too slow when database have approximately 1 million records [message #600693 is a reply to message #600692] Mon, 11 November 2013 05:20 Go to previous messageGo to next message
qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN
Senior Member
But Reports Speed are Excelent
Re: forms 6i too slow when database have approximately 1 million records [message #600698 is a reply to message #600693] Mon, 11 November 2013 05:58 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How many new records do you save at a time (from a form)?

What happens when you do the same in SQL*Plus? How much time does that take?

Turn tracing on and see what spends that much time.
Previous Topic: Adaptive Cursor Sharing VS SPM
Next Topic: Please help me how to improve the performance of this query further.
Goto Forum:
  


Current Time: Thu Mar 28 07:51:30 CDT 2024