General discussion

Locked

Oracle Slow To Edit Records- Why

By Leehlc ·
Have an oracle 8 database. In this example, 162 records. Can add a record, no problem- fast only takes seconds. To edit a record, it takes 4-5 minutes to bring up record and longer to save changes. Any suggestions on where to start looking. This is with DBA access.

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Oracle Slow To Edit Records- Why

by mallette In reply to Oracle Slow To Edit Recor ...

Adding a record typically uses the SQL INSERT command - with no WHERE clause. Bringing up a record uses SELECT typically with a WHERE clause. Same with saving changes - uses and UPDATE with a WHERE. Poorly written SQL can be the cause of between 60-80% of RDBMS performance problems. You may also want to look at the locks on a table when doing the UPDATE. There's an excellent solution to SQL problems called LECCO SQL Expert, available for download at www.leccotech.com. I've been using it for months and it's excellent!

Collapse -

Oracle Slow To Edit Records- Why

by Leehlc In reply to Oracle Slow To Edit Recor ...
Back to Networks Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums