Package Apache/PHP/MySQL as a Downloadable?
Posted on 2007-03-17
I have recently developed a very specialized PHP script that takes a file uploaded through Apache, processes it using temporary tables in a MySQL database (no data is permanently recorded), and then produces a large amount of output data, which it displays. It was set up this way because, originally, I intended this all to occur (logically) on a webserver. Output statistics could be kept in an account, and information could be cross-referenced between reports.
Unfortunately, through some testing, I've realized that I don't have the resouces to make this happen as described reasonably and cost-effectively. Server-side processing of uploaded data (usually in the 2-5MB range) can take over 10 minutes (it processes the file line by line, usually in the 20k to 100k line range, and then modifies the table for each line depending on its composition), on top of bandwidth costs, makes this seem more reasonable as a downloaded application. I'd prefer not to waste the time re-writing this in another program with another data management system, so I'm trying to figure out if there's a way to convert this PHP application into a downloadable application (for Windows) with as little headache (and as low cost) as possible.