Cocoon sql transformer causing squid timeout

Discussion in 'XML' started by phil.a.jenkins@gmail.com, Dec 7, 2005.

  1. Guest

    Hopefully someone can provide a solution to this rather annoying
    problem - we have a Cocoon pipeline which ends thus:

    <!-- build the sql for insert and final stage of select -->
    T1 <map:transform type="xslt" src="stylesheets/buildsql2.xsl"/>

    <!-- run the sql -->
    <map:transform type="sql">
    <map:parameter name="*****" value="****"/>
    </map:transform>

    <!-- build the response -->
    T2 <map:transform type="xslt" src="stylesheets/buildresult.xsl"/>

    <!-- send the response -->
    <map:serialize/>

    The SQL queries in Transform T1 execute either SELECT or INSERT queries
    on a large meta-database, so the following performance characteristics
    apply:

    1. SELECT statements take a long time to
    'render' to the final xml result- i.e. Transform T2.

    2. INSERT statements take a long time to
    execute in the first place i.e. Transform T1.

    Now, if transform T2 takes a long time to execute (sometimes in the
    region of hours), there is no problems, the client will happily sit and
    wait for the data. Transform T1 on the other hand will cause the squid
    proxy (though which cocoon is accessed) to give a timeout error back to
    the client after x mins. The database INSERT however completes
    succesfully, regardless of this error.

    It seems apparent from this situation that a cocoon serializer will
    'stream' data back to the client through the proxy - but the transform
    steps must wait for well-formed XML before contacting the client. Is
    there any way of keeping a connection 'busy' while waiting for this
    transform (T1) to complete?

    PS Sadly we cannot change the timeout limit on the Squid proxy, which
    would have rendered this message redundant.
     
    , Dec 7, 2005
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Thomas S.
    Replies:
    0
    Views:
    597
    Thomas S.
    Nov 12, 2004
  2. Zlatko Hristov

    Python script to grep squid logs

    Zlatko Hristov, Apr 14, 2004, in forum: Python
    Replies:
    1
    Views:
    881
    Lee Harr
    Apr 15, 2004
  3. Eddie Butcher

    Zope, Squid and manage_workspace

    Eddie Butcher, Jun 11, 2004, in forum: Python
    Replies:
    0
    Views:
    322
    Eddie Butcher
    Jun 11, 2004
  4. CptDondo

    OT: squid-type cache for XML?

    CptDondo, Nov 14, 2006, in forum: HTML
    Replies:
    4
    Views:
    627
    Toby Inkster
    Nov 14, 2006
  5. s88

    hashtable...squid

    s88, May 31, 2005, in forum: C Programming
    Replies:
    1
    Views:
    373
    Jack Klein
    May 31, 2005
Loading...

Share This Page