Waspman
Posts: 948
|
| Posted: 09/29/2010, 6:04 AM |
|
I know how to get small amounts out, up to 5k, but what about more?
Anyone managed to get 10K, 20K out?
_________________
http://www.waspmedia.co.uk |
 |
 |
rbaldwin
Posts: 172
|
| Posted: 09/30/2010, 10:49 AM |
|
well you don't say what language
in vb.net beforeshow event
Page.EnableViewState=False
Response.ContentType="application/vnd.ms-excel"
Response.AddHeader("Content-Disposition","inline;filename=""YourReportName.xls""")
let's me output excel several MB in size.
|
|
|
|
Waspman
Posts: 948
|
| Posted: 09/30/2010, 11:23 AM |
|
Yeah that's the way I've always done it, but max I get before a time out is 5k. Just wondered if there was better way.
_________________
http://www.waspmedia.co.uk |
|
|
|
Oper
Posts: 1195
|
| Posted: 10/01/2010, 6:11 PM |
|
wasp...
that method is really for small file, no matter what other could said.
work but that not the way.
the best way is to output to CSV format
and link to that file generated
5K register is like 10sec average.
(but you would have to generate the output by your own, no grid builder
what database are you using?
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
Waspman
Posts: 948
|
| Posted: 10/02/2010, 1:56 AM |
|
Hi Oper. It's asp and access
_________________
http://www.waspmedia.co.uk |
|
|
|
Oper
Posts: 1195
|
| Posted: 10/04/2010, 4:30 PM |
|
in Access we used to do this way, long time ago (we swiched to MySQL)
we use this "Scripting.FileSystemObject"
to create a File named Whatever CSV
and create a loop writing all records to that file
The file Created will be a CSV Comma Delimited but excel will open like was a XLS file.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
|
