Hi all, I have an application that ingests a large number of calendar events from a data provider. The provider's recommended implementation for an adapter is to delete all prior calendar events, and then create all the events in the new list (sent daily). There are approximately 7000 rows in the main table, and roughly that number in each of 6 subtables. In addition, there is a calendar_event_type table, which I had hoped to use to drive the purge, by deleting the appropriate type, and letting the deletion cascade to the other tables.
I am using jboss3.2 and postgres 7.3, and my beans are using the Instance per Transaction flavor of CMP 2.x. I've tried two approaches -- first getting the complete list of calendar events and deleting one at a time. This is quite slow. The second was deleting the type as mentioned above. Both take way too long (hours when the process doesn't time out). Has anyone ever encountered/overcome a mass-deletion problem? Is one of the above approaches better to pursue? Thanks, fawce ------------------------------------------------------- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user