• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Could you please go through the problem and suggest solution to solve this problem

 
chandrakanth boga
Ranch Hand
Posts: 49
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
We need to enhance a particular functionality:-

The problem is :-
----------------------------------------------------------------------------

The basic implementation of the dbclean up process is completed. we need to enhance for removing the database records in a smaller chunks. As of now this program will try to delete millions of records, hence database will fail out of log space.
we are using Springs Framework to manage database.

----------------------------------------------------------------------------


We need to enhance the functionality so that it can remove data in chunks´┐Ż.
What we can do for this ??

Please send your solutions as soon as possible.
 
Rajah Nagur
Ranch Hand
Posts: 239
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Are you trying to delete records one by one or is it a single query?

What is the database?

You got to index the table (probably you might have already done).

Have a batch process and group your records as logical chunks; the best grouping would be based on date field (if there any such column exists).

One more thing "Are the deletes transactional"?

---just my thoughts..
 
chandrakanth boga
Ranch Hand
Posts: 49
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Rajah Nagur for your reply.

its s single query and database is DB2

i am not understanding whether deletes are transactional. but it deletes based on trade ids.
 
Ben Souther
Sheriff
Posts: 13411
Firefox Browser Redhat VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving to the JDBC forum where the database gurus hang out.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34214
341
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by chandrakanth boga:
i am not understanding whether deletes are transactional. but it deletes based on trade ids.

Rajah is asking whether you have it set up so that the whole process will rollback if one delete fails?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic