Professional Web Applications Themes

UNIX-Box slow down while execute stored procedure - Informix

Removed by Administrator...

  1. Moderated Post

    Default UNIX-Box slow down while execute stored procedure

    Removed by Administrator
    Kai Guest
    Moderated Post

  2. Moderated Post

    Default RE: UNIX-Box slow down while execute stored procedure

    Removed by Administrator
    Murray Wood \(IList\) Guest
    Moderated Post

  3. #3

    Default Re: UNIX-Box slow down while execute stored procedure

    "Murray Wood \(IList\)" <ifxmaillistquanta.co.nz> wrote in message news:<bn22qc$7b0$1terabinaries.xmission.com>...
    > Start with ...
    >
    > When you run the procedure from dbaccess on the server how long does it
    > take?
    > Do you have the explain plan for the sqls in the procedure? (set explain on;
    > update statistics for your_procname;)
    >
    from dbaccess it is the same problem (run up to an hour and kills the
    unix-performance)

    the explain shows some sequential scans when the update(s) runs for
    all entries or when the where-clause goes over the temp table columns
    whitout an index.
    We have testet with some indexes (seq. scans replaces with index path)
    but nothing helps ... the session require too many - whatever
    Kai Guest

Similar Threads

  1. execute stored procedure
    By Buda123 in forum Coldfusion Database Access
    Replies: 1
    Last Post: April 29th, 09:26 PM
  2. Execute permission denied on 'stored procedure' dbo
    By Prasath in forum ASP.NET Web Services
    Replies: 0
    Last Post: October 13th, 08:57 AM
  3. Problem with execute to make a stored procedure
    By Cecil Westerhof in forum ASP Database
    Replies: 6
    Last Post: March 1st, 05:29 PM
  4. Cannot execute dynamic query in stored procedure
    By Net in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 4th, 09:13 PM
  5. How can I execute a stored procedure in .net?
    By FireListen in forum ASP.NET General
    Replies: 1
    Last Post: June 27th, 01:39 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139