OraFAQ Forum: Performance Tuning » forms 6i too slow when database have approximately 1 million records

Home » RDBMS Server » Performance Tuning » forms 6i too slow when database have approximately 1 million records (Oracle 8i)

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

forms 6i too slow when database have approximately 1 million records [message #600618]

Sat, 09 November 2013 08:13

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

forms 6i too slow when database have approximately 1 million records

Regards

Report message to a moderator

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

Littlefoot
Messages: 21823
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.

Report message to a moderator

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

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

Report message to a moderator

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

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

But Reports Speed are Excelent

Report message to a moderator

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

Littlefoot
Messages: 21823
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.

Report message to a moderator

Previous Topic:	Adaptive Cursor Sharing VS SPM
Next Topic:	Please help me how to improve the performance of this query further.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 11:55:17 CST 2025