On Sep 21, 2007, at 9:45 AM, Giulio Cesare Solaroli wrote:
I have tried to attach the logs and the model to the message, but the maililng list system has rejected it has spam. :-(
Apache has strong anti-spam controls in place for email. You can open a jira issue and upload files to the issue... Craig
If the full log and/or model could be useful in understanding the problem, I will upload them somewhere else. Hello Aristedes, thanks for your reply. Before answering your questions, let me describe my "environment": I am running everything on my own MacBookPro, with Postgresql running on a CentOS based Parallels virtual machine, while tomcat is running on the MacOS environment. This is definitely not a performance wise reference configuration, but 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 process takes about 7 minutes for a regular account. This is much more than we can bear for any operation.That does seem extraordinary. Can you give us some background: * how many records are deletedabout 100 objects, from 6/7 different tables.* what version of Cayenne you are using2.0.2* what database are you usingPostgreSQL, probably version 8.1* can you get a log of the sql being executed and discover what precisely is taking so longI have attached the full log (and also the zip of the cayenne model, in case it is relevant); but the odd part is highlighted here (at the begin of each line is the time stamp with format "hh:mm:ss"): [18:09:40] DELETE FROM clipperz.RCRVRS WHERE ID_RCRVRS = ? [18:09:40] [batch bind: 968] [18:09:40] [batch bind: 875] [......] [18:09:40] [batch bind: 1177] [18:09:40] [batch bind: 2792] [18:11:54] === updated 68 rows. In this case, to delete just 68 rows it took more than two minutes, but I don't know if this time is spent somewhere inside the cayenne code, or if this is simply the time it took PostgreSQL to "physically" delete the rows. Do these details help understanding what is going on? Thanks, Giulio Cesare
Craig Russell Architect, Sun Java Enterprise System http://java.sun.com/products/jdo 408 276-5638 mailto:[EMAIL PROTECTED] P.S. A good JDO? O, Gasp!
smime.p7s
Description: S/MIME cryptographic signature
