Fw: Re: Context Commits

From: Dirk Wellmann (d..dsoft.de)
Date: Fri Nov 19 2004 - 02:53:59 EST

  • Next message: johannes schmidt: "Very strange behavior of my cayenne application"

    Hi Gary,

    I would take a simple, pragmatic solution for that. Just make a counter and
    every n - records do a myDataContext.commit().

    You wrote 2000+ per Second and per Minute, if its per Second then I think you
    could get in trouble but just check it out.

    br

    Dirk

     Ihre Mail vom Fri, 19 Nov 2004
    13:58:15+1100(Gary Jarrel["Gary Jarrel"<garyjarre..rownbilljarrel.com.au>]):
    > Hi Guys!
    >
    > Sorry for pounding the list with strange message. If you read my previous
    > post we've got a database with a single table to log SMS messages being sent
    > by user. We've created a high performance server that is capable of sending
    > 2000+ SMS messages per second. As I'm trying to log the messages that means
    > more than 2000+ database inserts per minute which is a big performance hit.
    >
    > The ideal situation would be to set a limit that keeps the objects in an
    > uncommitted state until there are for example 10 records (or some other
    > defined value) to commit and then commits all at once.
    >
    > Would anyone have any ideas on the best way of doing this?
    >
    > Thanks.
    >
    > - Gary

    This archive was generated by hypermail 2.0.0 : Fri Nov 19 2004 - 02:47:35 EST