Hi David,
I got a few questions and few suggestions:
Do you need to run the report on the client machine? Thats a huge report...300000 records.
I was thinking that you may be able to run the process on the server, dump the data into a report table and , when its done, send the formatted data to the client, ready for the report. It still wont be very fast but definately faster then running the whole show on the client.
As far as serializing a dataset as big as the one you are sending to client, .net serialization performance will degrade big time. I suggest you take a look at a Microsoft freebie called DataSetSurrogate (search msdn for) that does a better serialization of large datasets. This, along with compressing and streaming the dataset would work perfectly. You can use Xceed for compressing and streaming ( Thanks Dave Foderick for the pointer:)
Im currently working on a smart client app that downloads data(datasets) and I can load 600000 records very fast( via remoting). I m using DataSetSurrogate, Xceed for compression and streaming and remoting.
As Thomas Ganss suggested, msde might be another option here for dumping those 300000 records and processing the report on the client.
Hope it helps,
Vlad
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only