• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

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

 
Ranch Hand
Posts: 49
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 239
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Sheriff
Posts: 13411
Firefox Browser VI Editor Redhat
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Moving to the JDBC forum where the database gurus hang out.
 
author & internet detective
Posts: 41860
908
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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?
 
You firghten me terribly. I would like to go home now. Here, take this tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic