Home » RDBMS Server » Performance Tuning » How To Increase Data Reterival / Insertion Speed (Oacle 8i and Forms 6i)
How To Increase Data Reterival / Insertion Speed [message #599407] Thu, 24 October 2013 04:33 Go to next message
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
Re: How To Increase Data Reterival / Insertion Speed [message #599409 is a reply to message #599407] Thu, 24 October 2013 04:39 Go to previous messageGo to next message
ThomasG
Messages: 3211
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.

icon13.gif  Re: How To Increase Data Reterival / Insertion Speed [message #599410 is a reply to message #599407] Thu, 24 October 2013 04:47 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

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


Current Time: Thu Mar 28 08:17:20 CDT 2024