Professional Web Applications Themes

CF Server Choking When Calling STORED PROC - Coldfusion Database Access

Experts, I really hope someone can help out with this problem. I have a ColdFusion 5 server running on a windows 2000 server. Our application is basically a reporting tool that runs pretty heavy queries. In the past, queries were run in <cfquery> tags; after moving to <cfstoredproc> as a more centralized technique, the whole application hangs until a cfstoredproc returns its results. This happens across all users (10000+) and not just the same user with two open sessions. This means that if someone is running a report that returns in 9 minutes, all other users cannot perform any activity ...

  1. #1

    Default CF Server Choking When Calling STORED PROC

    Experts,

    I really hope someone can help out with this problem.

    I have a ColdFusion 5 server running on a windows 2000 server.

    Our application is basically a reporting tool that runs pretty heavy queries.
    In the past, queries were run in <cfquery> tags; after moving to <cfstoredproc>
    as a more centralized technique, the whole application hangs until a
    cfstoredproc returns its results. This happens across all users (10000+) and
    not just the same user with two open sessions. This means that if someone is
    running a report that returns in 9 minutes, all other users cannot perform any
    activity on the entire application until this report is rendered. Of course
    when I say "any activity" I mean any database interaction - and since all our
    pages access the database the entire applications just FREEZES until the
    cfstoredproc is finished.

    We have been advised to move from ODBC to Native Data Sources but that didn't
    help much. Please note that the database is Oracle 9i and that some of these
    queries take well over 5 minutes to return.

    mostof Guest

  2. #2

    Default Re: CF Server Choking When Calling STORED PROC

    anyone?
    mostof Guest

  3. #3

    Default Re: CF Server Choking When Calling STORED PROC

    Check your stored procedures transaction handling. Make sure your not locking
    the whole table. When doing select statements you should do readcommited
    transactions.

    Also, make sure connection pooling is enabled in your ODBC settings.

    thejuggler Guest

Similar Threads

  1. cfc and stored proc
    By mcoop in forum Coldfusion - Advanced Techniques
    Replies: 1
    Last Post: April 13th, 05:09 PM
  2. Calling webservice from within a stored proc 407 error...
    By Doug in forum ASP.NET Web Services
    Replies: 0
    Last Post: September 15th, 09:18 PM
  3. stored proc RETURN value in ASP
    By ben h in forum ASP Database
    Replies: 2
    Last Post: June 17th, 11:02 AM
  4. ASP vs Stored Proc vs UDF
    By Brad in forum ASP Database
    Replies: 11
    Last Post: October 28th, 01:46 AM
  5. stored proc and tcp/ip
    By Helmut Wöss in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: June 30th, 08:13 AM

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