Hello,
I am still fighting with the very slow deletion problem I had a few
weeks ago. Now I probably have understood what is causing it.
I have defined most, if not all the constraints in my db schema as
DEFERRABLE INITIALLY DEFERRED.
In Postgres (but probably also in other DB), this causes the
eSQL
instance is running the same query 20 to 100 times faster, there is
something else to fix before tuning the memory.
> * Ask on [EMAIL PROTECTED]
Great pointer. Thanks :-)
Best regards,
Giulio Cesare
> On Oct 1, 2007, at 19:05 , Giulio Cesare Solaroli wrote:
>
> > Ye
much further) and bad news (I need to learn how to
tune a PostgreSQL db, or find someone that could help).
Best regards,
Giulio Cesare
On 10/1/07, Michael Gentry <[EMAIL PROTECTED]> wrote:
> Have you vacuumed the original (slow) table?
>
> /dev/mrg
>
> On 10/1/07, Giul
lio Cesare
On 9/23/07, Giulio Cesare Solaroli <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I have collected a few more data, as suggested by Aristedes.
>
> On 9/23/07, Giulio Cesare Solaroli <[EMAIL PROTECTED]> wrote:
> > On 9/23/07, Aristedes Maniatis <[EMAIL
Hello,
I have collected a few more data, as suggested by Aristedes.
On 9/23/07, Giulio Cesare Solaroli <[EMAIL PROTECTED]> wrote:
> On 9/23/07, Aristedes Maniatis <[EMAIL PROTECTED]> wrote:
> >
> > On 23/09/2007, at 5:38 PM, Giulio Cesare Solaroli wrote:
> >
>
On 9/23/07, Aristedes Maniatis <[EMAIL PROTECTED]> 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 anyt
Hello Aristedes,
On 9/23/07, Aristedes Maniatis <[EMAIL PROTECTED]> wrote:
>
> 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
Hello Andrus,
thank you very much for the pointers; I will start digging them soon.
Best regards,
Giulio Cesare
On 9/22/07, Andrus Adamchik <[EMAIL PROTECTED]> wrote:
>
> On Sep 22, 2007, at 4:41 PM, Giulio Cesare Solaroli wrote:
> >
> >>> The SQL I am expec
On 9/22/07, Andrus Adamchik <[EMAIL PROTECTED]> wrote:
>
> On Sep 21, 2007, at 7:45 PM, Giulio Cesare Solaroli wrote:
>
> >
> > [18:09:40] DELETE FROM clipperz.RCRVRS WHERE ID_RCRVRS = ?
> > [18:09:40] [batch bind: 968]
> > [18:09:40] [batch bind: 875]
> &
Hello,
On 9/22/07, Michael Gentry <[EMAIL PROTECTED]> wrote:
> FWIW:
>
> I run PostgreSQL on OS X and it is plenty fast enough. The downside
> to PostgreSQL on OS X is there isn't an installer, so it is more work
> to build and install. If you are Unix-savvy, though, this won't be
> much of a pr
t
I am not comfortable with these times anyway.
On 9/21/07, Aristedes Maniatis <[EMAIL PROTECTED]> wrote:
>
> On 22/09/2007, at 12:31 AM, Giulio Cesare Solaroli wrote:
>
> > When I try to delete an user, all the cascade rules are correctly
> > applied, but the all proces
Hello everybody,
I am facing a performance bottle neck while commiting the dataContext
when many "cascade" rules are applied to relevant relationships.
This scenario is quite simple: in my db schema there is a core entity
that is the User; this entity has many subordinate information that
are col
lient-nodeps.jar.
Andrus
On Apr 26, 2007, at 6:03 PM, Giulio Cesare Solaroli wrote:
> Hello everybody,
>
> I was trying to trim the size of my application war replacing the full
> cayenne jar with the client one.
>
> But when compiling the application using the
> cayenne-client-n
Hello everybody,
I was trying to trim the size of my application war replacing the full
cayenne jar with the client one.
But when compiling the application using the
cayenne-client-nodeps.jar, the compiler barks about a missing symbol:
class CayenneDataObject.
I have opened the jar, and the Cay
14 matches
Mail list logo
