I'm hoping someone here has run into this oddball. I'm accessing a Filemaker DB through php/odbc and running even small queries creates giant temporary files that are mostly blank spaces. For example, one query returns about 113 rows but creates a 987meg temporary file. Here's the kicker: I grabbed one of the temporary files and compressed it via 7z at default settings and it's 148k! That's slightly less than the amount of data the query is actually displaying.
Why does it need a gig of nearly blank space in a temporary file to display about 1 page of actual text? No images are involved.
Here's the code. Don't get me started on the quotes thing, the driver wouldn't have it any other way.
$sql='select "Database"."a","Database"."b","Database"."c","Database"."d","Database"."e" from "Database" where "Database"."car" like \'%ACC%\' and "Database"."SubSection" = \''.$sec.'\'';
$rs=odbc_exec($conn,$sql);