• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Urgent -- SQL Help

 
Prasanna KumarBP
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
We have a problem here. We have a situation in which we will be inserting a row in a table. Now after a time interval of say 5 minutes we want to delete this row. Is there any easy means of doing this in SQL. We know that a Scheduled object in java can do the job. But we would like to know if this can be achieved at SQL level, which whould be faster than our approach.
Kindest Regards
....Prasanna
 
Robert Brunner
Ranch Hand
Posts: 49
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Why are you storing something in a Database for only five minutes? Sounds to me like you need to rethink your design. Why not just serialize the data to a temporary file. If you really need to do this, I would suggest you look at using a stored procedure, but this becomes database specific, thus I can't give more information.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic