generare report

Question

Hi,

 

i am working on larger scale ecommerce application we got requirement to generate execel report on entire orders. to get the report in sql it is taking too long  time because of huge data..please suggest us various ways to do that