Re: Optimize cascade deletes

From: Giulio Cesare Solaroli (giulio.cesar..mail.com)
Date: Sun Sep 23 2007 - 06:20:44 EDT

  • Next message: Malcolm Edgar: "Re: Best practices for using Cayenne's ObjectContext in a web framework?"

    On 9/23/07, Aristedes Maniatis <ar..aniatis.org> wrote:
    >
    > On 23/09/2007, at 5:38 PM, Giulio Cesare Solaroli wrote:
    >
    > > log4j.logger.org.apache.cayenne=ERROR
    > > log4j.logger.org.apache.cayenne.access.QueryLogger=DEBUG
    > >
    > >
    > > Is there anything going on on the Cayenne code between the last [batch
    > > bind:xxx] log and the "updated" log?
    >
    > Well, you could always try:
    >
    > log4j.logger.org.apache.cayenne=DEBUG

    Argh. I should have thought about this myself. :-(

    > > Is all this time spent on the DB only?
    >
    > What does turning on log_min_duration_statement tell you?

    Woow!! This is a great reference for PostgreSQL debugging!!

    I will try to apply both suggestion and run the tests again.

    Thank you very much for your attention.

    Best regards,

    Giulio Cesare

    >
    > Ari Maniatis
    >
    >
    >
    > -------------------------->
    > Aristedes Maniatis
    > phone +61 2 9660 9700
    > PGP fingerprint 08 57 20 4B 80 69 59 E2 A9 BF 2D 48 C2 20 0C C8
    >
    >
    >
    >

    This archive was generated by hypermail 2.0.0 : Sun Sep 23 2007 - 06:21:13 EDT