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

Reply via email to