Kasper Skårhøj, head developer of TYPO3, has announced a new feature for TYPO3 4.0: database indexing.

Databases allow you to specify indexes for every column of a table, which in turn can dramatically increase query speed. The indexes are automatically updated by the database, saving developers the trouble of doing it themselves.

Kasper has implemented a similar concept for TYPO3. The system provides a table to hold all references to TYPO3 content elements. For example, a short query on this table can provide the users connected to a backend usergroup. These references are normally stored in a comma separated list, which makes such queries very complex.

The main reason for implementing database indexing is the new integrity check functions available in TYPO3 4.0. The indexing is done by the TYPO3 Core Engine, and developers can use the methods provided by TYPO3; it should work "out of the box".

This is a very short overview; to view the whole text, please go to:

http://lists.netfielders.de/pipermail/typo3-dev/2005-December/014275.html

Greets,

Thomas

P.S.: This text is copied from http://news.typo3.org. I wrote that text so I think it's okay when I release it here too. :-/