Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2008
    Posts
    14

    Unanswered: Slow weird view performance

    Hey All,

    I am running into a strange issue.

    My view runs in around 175ms under normal operations, but as soon as we start to add/delete/update data in our tables the view starts to slow down dramatically.

    However, when we create or replace the exact same view it runs vast right away and again runs in around 175ms. So it's not the SQL that is slow, but 'something else'.

    any thoughts on this?

    Ries

  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    how long before it starts to slow down?
    (how many records are added, percentage-wise?)
    if you vacuum the tables, doesa the performance improve again?
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


  3. #3
    Join Date
    Mar 2008
    Posts
    14
    Quote Originally Posted by loquin
    how long before it starts to slow down?
    Only after we modify tables, can be done by adding fields or by adding/removing/updating data. We couldn't pinpoint this yet.

    Quote Originally Posted by loquin
    (how many records are added, percentage-wise?)
    About 25% would be my best guess...

    Quote Originally Posted by loquin
    if you vacuum the tables, doesa the performance improve again?
    It doesn't, only replacing the view works to speed it up....


    That's the strange thing, we just CREATE OR REPLACE the view and it's fast again. It almost looks like if the execution plan get's stored, which is not really possible.... is it??

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •