TechRepublic|Forums|Networks

Networks

General discussion

  • Creator
    Topic
  • May 23, 2000 at 8:57 am #2082469

    Oracle Slow To Edit Records- Why

    Locked

    by leehlc · about 24 years, 5 months ago

    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.

    Topic is locked This conversation is currently closed to new comments.
  • Creator
    Topic

All Comments

  • Author
    Replies
    • May 30, 2000 at 3:11 am #3892157

      Oracle Slow To Edit Records- Why

      by mallette · about 24 years, 4 months ago

      In reply to Oracle Slow To Edit Records- Why

      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 http://www.leccotech.com. I’ve been using it for months and it’s excellent!

  • Author
    Replies
Viewing 0 reply threads