You have a slow query. 1000 records is a little set for today computing power. Can you give details on the query? Which database are you using?
Try using SQL directly by the executesql method of dal. mic Il giorno 12/gen/2012 07:46, "Saurabh S" <[email protected]> ha scritto: > Hi, > > I am developing an online booking system. one of the functionality > that i have implemented is to generate reports by gathering the data > from two or more different tables. the problem that i am facing is due > to large number of records (greater than thousand) , i was unable to > render all the records into the view.(request time out) . to overcome > this i implemented pagination which displays the records in small sets > (using limitby filter on the database). by implementing the pagination > i was able to remove the error while viewing the data. > But in addition to viewing , i also have the functionality to > download the same report in csv. due to the large data size i am > unable to download the csv. it gives me deadline exceeded error. > > Please note my requirement is to download whole set of report in one > csv.(more than 1000 records) > > I am thinking of implementing task queues for this ? > > Please suggest any solution for this. > > Thanks in advance > > > >
