Skip to main content

Increase the Speed of Reading XLSX Files

This blog post might be outdated!
This blog post was published more than one year ago and might be outdated!
· 2 min read
Florian Horn
Florian Horn

A few month ago, I wrote an article about some PHPExcel performance tweaks. Sadly we encountered some nasty memory exhaustion issues while reading big XLSX files with PHPExcel. The issues does not occur directly in PHPExcel, furthermore the current PHP process is killed in the SimpleXML/LibXml library execution silently, without any exception or error notification.

Vagrant 1.8 supports Linked Clones

This blog post might be outdated!
This blog post was published more than one year ago and might be outdated!
· One min read
Stephan Hochdörfer
Head of IT Business Operations

When browsing the Vagrant 1.8 Changelog file I realized that the latest Vagrant version supports Linked Clones which according to the Changelog means that imports during the vagrant up process will run much faster than before. Since it did not work out-of-the-box for me, I had to dig deep in the Vagrant documentation to figure out that you need to explicitly enable the feature. Simply add the following lines to your Vagrant configuration and your vagrant up command will probably run faster than ever:

Vagrant 1.8 Upgrade Issues

This blog post might be outdated!
This blog post was published more than one year ago and might be outdated!
· 2 min read
Stephan Hochdörfer
Head of IT Business Operations

Earlier this morning Mitchell Hashimoto released version 1.8 of Vagrant. I immediately upgraded and quickly hit a problem. After running vagrant up I got this error message:

PostgreSQL - Count() Performance Boost

This blog post might be outdated!
This blog post was published more than one year ago and might be outdated!
· 3 min read
Florian Horn
Florian Horn

Counting is a slow measure in Postgresql, and it is even slower with a lot of data and complex statements. This issue is related with the kind of how the data consistency is implemented. As a result Postgresql must check the visiblity of all rows first and so it has to iterate over them all.

PHPBenelux 2016 conference

· One min read
Stephan Hochdörfer
Head of IT Business Operations

Vom 29.01.2015 bis zum 30.01.2015 findet in Antwerpen bereits zum siebten Mal in Folge die phpBenelux Konferenz statt. Ich freue mich wieder einmal, als Sprecher eingeladen worden zu sein. In meinem Vortrag "Jenkins for PHP Projects" werde ich aufzeigen wie wir Jenkins für unsere PHP Projekte verwenden und wie bsp. die Zusammenarbeit mit unserer internen Satis Instanz funktioniert.

Cache Breaking your Sencha application

This blog post might be outdated!
This blog post was published more than one year ago and might be outdated!
· 2 min read
Michael Spahn
Michael Spahn

Cache is a great thing, but sometimes it causes problems. For example deploying the latest web app but users still having cached JS, CSS files and more cached in their browser. This is not a bad thing in a lot of cases, but consider, you did an API change and the cached JS is still accessing the old API.