zipping problem



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




.



Relevant Pages

  • Re: Memory consumption PowerShell
    ... Why need a running CMD.Exe on Windows Server 2003 only 144 KB??? ... With best regards ... And we could initiate to run a script oout side the IDN 3.0. ... memory. ...
    (microsoft.public.windows.server.scripting)
  • Re: ANY Win32_Printer query leaks ~500kbytes in wmiprvse.exe
    ... I can't repro this problem you are describe below is all, ... All the script does below is put the remote server into a loop and does what ... >> Use of memory by Windows is much more complex than most of us know about. ...
    (microsoft.public.win32.programmer.wmi)
  • Re: Reboot command no longer works in Task Scheduler
    ... You can script it. ... Fixing the memory leak and blue screen stop error makes the best sense to me. ... Server event viewer log file, if there are IDs such as 8250, 8026, 2102, then ...
    (microsoft.public.win2000.general)
  • Re: Segmentation fault in php5-imap
    ... The PHP memory limit is 512 Mb and server has 16Gb of RAM, so it doesn't look like its exhausting all the memory, although one of the libraries potentially could? ... It looks like the script is dropping connection to the NNTP server. ...
    (php.general)
  • Re: Same Internal Server Error from last two days
    ... I am trying to run a Hello World Perl Script in Apache 2.2. ... But its constantly giving me Internal Server Error.The script ... # have to place corresponding `LoadModule' lines at this location so the ...
    (perl.beginners)