|
|
Posted by Brian on 10/10/59 11:17
Hi all (again)
First off sorry for all the recent post, this little site I'm
working on is turning into the thorn in my side.
Right I have a script that zips files on the fly.
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=957&lngWId=8
All works find, except when I try to export a big file.
My script runs a MySQL query, which in turn builds up
a big string of comma separated values, which in turn gets
zipped up into a csv file.
The trouble is some of these queries are BIG, in fact if I
were to write them out to a file first they can be as big as
25Mb, and the server can't hold a 25Mb string in memory
before it zips it Even if i wrote them out first i still need to
read it back in to memory to run the zip function.
So I was thinking is working out the max size the server can
handle, and breaking the zipped files up into smaller files so the
user downloads several files instead
But has anybody else got a better ideas or suggestions?
Brian
Navigation:
[Reply to this message]
|