Databases
StackOverflow2013
Postsdbo
POCompressing xls content with apache deflate module
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCompressing xls content with apache deflate module
    primarykey
    data
    text
    <p>I am trying to compress an excel spreadsheet being sent from my application using apache deflate module. I have added the following line to the my sites-enabled file:</p> <pre><code>AddOutputFilterByType DEFLATE text/html text/plain text/xml text/css text/javascript application/excel </code></pre> <p>But is seems to make the response data bigger???</p> <p>Using firebug, without the module I downloaded the xls spreadsheet from the application and it downloaded 100Kb of data, the file size once on the filesystem was also 100Kb as expected. Once I enabled the deflate module as described above and repeated the process, the amount of data downloaded was 295Kb?? but the file was still only 100Kb once save on the filesystem. </p> <p>As an experiment I manually gzipped the saved xls file and it compressed to 20Kb.</p> <p>What am I doing wrong here?</p> <p><strong>Using deflate (Firebug output):</strong></p> <pre><code>200 OK xxxxxxx.co.za 293 KB 4.43s ParamsHeadersPostPutResponseCacheHTML Response Headers Date Tue, 03 Nov 2009 13:01:43 GMT Server Apache/2.2.4 (Ubuntu) mod_jk/1.2.23 PHP/5.2.3-1ubuntu6.4 mod_ssl/2.2.4 OpenSSL/0.9.8e Content-Disposition attachment; filename="Employee List.xls" Vary Accept-Encoding Content-Encoding gzip Content-Type application/excel </code></pre> <p><strong>Without deflate (Firebug output):</strong></p> <pre><code>200 OK xxxxxxxx.co.za 100 KB 3.46s ParamsHeadersPostPutResponseCacheHTML Response Headers Date Tue, 03 Nov 2009 13:06:00 GMT Server Apache/2.2.4 (Ubuntu) mod_jk/1.2.23 PHP/5.2.3-1ubuntu6.4 mod_ssl/2.2.4 OpenSSL/0.9.8e Content-Disposition attachment; filename="Employee List.xls" Content-Length 102912 Content-Type application/excel </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USClinton Bosch
    1. USClinton Bosch
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POCompressing xls content with apache deflate module
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POCompressing xls content with apache deflate module
      1. USDavid Tinker
      1. VTFavorite
    3. VO
      singulars
      1. POCompressing xls content with apache deflate module
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIs the gzipped request body actually valid gzip data? Did you try to debug with `curl`?
      singulars
      1. POCompressing xls content with apache deflate module
      1. USEemeli Kantola
    2. COI did not use curl, but as described, I can manually gzip the file and it compresses from 100Kb to 20Kb
      singulars
      1. POCompressing xls content with apache deflate module
      1. USClinton Bosch
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload