• Post Reply Bookmark Topic Watch Topic
  • New Topic

bulk downloads online - best method???  RSS feed

 
James Kesari
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
We are intending to build a bulk download system for one of our clients. The intention here is,
1) User would click download button
2) The system would go to the database picks millions of records and present in a .csv format so user can save it in his local desktop. This process would take about 20 minutes [after efficient tuning of sql procedures and tables].

I just want thoughts from you on the best way to present this to the user and what is the best way to implement this?
Any thoughts would be of great help!!!

Thanks...
 
Mark Spritzler
ranger
Sheriff
Posts: 17309
11
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Well if the querying process will take a while, and it would be ok to send the file via Email. I highly suggest using Asynchronous messaging, and queue up the requests, create the file, then email the file back to the user, instead of having them wait.

Mark
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!