Toggen

Selected posts

Use FORCE INDEX

Just putting this here as I have a SELECT in MySQL that was taking 1.946 sec to return 20 records from a table with 159884 records when using a ORDER BY DESC on a DATETIME field Creating an index and changing the FROM to FORCE INDEX () dropped it down to 0.00079 sec /...

Using a git repo as a composer repository

So here is the link so I don't forget it https://getcomposer.org/doc/05-repositories.md#vcs Add your repo's URL into your composer.json in the repositories key and change the version on the original repo name to your dev-* version where * is a branch of your github...

glabels-3-batch on Fedora 25 segfault

The default glabels-3.4.x install on Fedora 25 through 29 segfaults when using the glabels-3-batch command. The following command fails: glabels-3-batch -o output.pdf -i crossdock-data.csv 150x200-crossdock-labels.glabels I found compiling from source with defaults...

seLinux won’t exec my .pl

This error in httpd error_log [Wed Jul 12 21:39:57.069313 2017] [cgi:error] [pid 16811] [client 127.0.0.1:35330] AH01215: (13)Permission denied: exec of '/home/rupert/Sites/client1-www/cgi-bin/refnum.pl' failed:/home/rupert/Sites/client1-www/cgi-bin/refnum.pl [Wed Jul...