my $input= pipethrough_prep();
print $input $cplex or die $!;
my $output= pipethrough_run_along($input, undef, 'glpsol',
- qw(glpsol --tmlim 5 --memlim 5), @opts,
+ qw(glpsol --tmlim 5 --memlim 20), @opts,
qw( --cpxlp /dev/stdin -o /dev/stdout));
if ($qa->{'debug'}) {
print "<h3>@opts</h3>\n<pre>\n";
<%perl>
my $sth_i= $dbh->prepare(<<END);
SELECT archipelago, islandid, islandname, timestamp
- FROM uploads NATURAL JOIN islands
+ FROM uploads JOIN islands USING (islandid)
WHERE islandid = ?
END
my $sth_a= $dbh->prepare(<<END);
SELECT archipelago, islandid, islandname, timestamp
- FROM uploads NATURAL JOIN islands
+ FROM uploads JOIN islands USING (islandid)
WHERE archipelago = ?
ORDER BY islandname
END