MySQL may use temporary tables during query execution. Ideally you would want to avoid this, since its an expensive and slow operation. It can be avoided by optimizing queries. Sometimes it can’t be completely avoided – in that case you want to make sure the temporary table is created as a “memory” storage engine table,… Read more »
Posts Categorized: Web 2.0
DAM firms disappearing
I found this article in eWeek really interesting: Midmarket Digital Asset Management Firms Disappearing Companies are drowning in content they generate, usually with no way to organize it. Furthermore, as the article states, there is less and less support for SMBs, who can’t spend a fortune on software. Normally new firms would enter the market… Read more »
Timezones in TYPO3
This took me some time to analyze, so I thought I would post it to save time to anyone faced with the same problem. TYPO3 handles timezones, making sure that whatever input it gets is timezone-aware, both server-side, and client-side. Any input in TCEforms that is set to be evaluated as a datetime must be… Read more »
NuSphere PHPed 5.6
The new version of the greatest PHP IDE is officially out!! Here is the official list of key features: PHP Debugging enhancements Settings Wizard provides an easy to use, simple UI to help you start debug PHP scripts in any environment Support for multiple Parallel debugging sessions. You can debug multiple PHP Scripts simultaneously and… Read more »
FTP with TYPO3
TYPO3 has a table for backend users. Those users need to occasionally upload files to the fileadmin directory via FTP. Wouldn’t it be nice to configure the FTP server to pull from the be_users table and authenticate them, so that two separate locations for userdata don’t have to be maintained? It’s possible. This guide documents… Read more »