OraFAQ Forum: Performance Tuning » How To Increase Data Reterival / Insertion Speed

Home » RDBMS Server » Performance Tuning » How To Increase Data Reterival / Insertion Speed (Oacle 8i and Forms 6i)

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

How To Increase Data Reterival / Insertion Speed [message #599407]

Thu, 24 October 2013 04:33

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

How To Increase Data Reterival / Insertion Speed my data base has more than 0.5 million records Forms Some Time Respond Very Slow

Regards

Report message to a moderator

Re: How To Increase Data Reterival / Insertion Speed [message #599409 is a reply to message #599407]

Thu, 24 October 2013 04:39

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Based on the information you give the only solution that can be made is "Buy faster hardware".

All other solutions would require the information outlined in the Sticky Post at the top of the Performance Tuning Section.

Report message to a moderator

Re: How To Increase Data Reterival / Insertion Speed [message #599410 is a reply to message #599407]

Thu, 24 October 2013 04:47

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And also the first answer would be "upgrade to a version that was not designed in the last century".

Report message to a moderator

Previous Topic:	db file parallel read
Next Topic:	standard SQL query to benchmark Oracle DB response time (performance)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 06 07:25:47 CST 2025