Re: Optimize cascade deletes

From: Aristedes Maniatis (ar..aniatis.org)
Date: Sat Sep 22 2007 - 20:28:59 EDT

  • Next message: Aristedes Maniatis: "Re: Transactions , Primary Keys"

    On 22/09/2007, at 11:41 PM, Giulio Cesare Solaroli wrote:

    > 15 seconds are a lot of time, but they would be bearable. The problem
    > is that I suppose this time will gradually increase with the growth of
    > the number of records to delete.

    That is still about 1000 times the duration I'd expect this to take.
    There is still a significant problem which you might be able to
    identify with some profiling or logging.

    Ari

    -------------------------->
    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 : Sat Sep 22 2007 - 20:29:41 EDT