D
dbeavon
Guest
I'm using OE 11.3 on HP-UX. I have type 2 storage areas. I've started up a number of separate process (eg 10) to delete data out of the same table. Each process is started with a parameter to say what needs to be deleted within that process. The processes seem to do the table deleting work *slower* in parallel (as a team) than if I just run a single process. I think there must be some massive concurrency problem in OE related to deletes. Is OE taking an entire table lock or such, just in order to delete a single record? Or perhaps the indexes are the concurrency bottleneck? Any tips on how I should go about this? At the moment we are trimming old data (prior to a certain date). Each process is trimming data for a different part of the organization. Should I be disabling indexes (ie ones that don't contribute to the partitioning of the organization's data)? Any help would be appreciated. Thanks, David
Continue reading...
Continue reading...