Zum Inhalt

Übersetzungshinweis

Leider war es uns noch nicht möglich, diese Seite für Sie auf Deutsch zu übersetzen. Wir zeigen daher stattdessen die englischsprachige Version der Seite und bitten um Verständnis.

Additional database indices#

If you have a large i-ticket database, some features such as search for orders or events might turn pretty slow. For PostgreSQL, we have compiled a list of additional database indexes that you can add to speed things up. Just like any index, they in turn make write operations insignificantly slower and cause the database to use more disk space.

The indexes aren't automatically created by i-ticket since Django does not allow us to do so only on PostgreSQL (and they won't work on other databases). Also, they're really not necessary if you're not having tens of thousands of records in your database.

However, this also means they won't automatically adapt if some of the referred fields change in future updates of i-ticket and you might need to re-check this page and change them manually.

Here is the currently recommended set of commands:

Also, if you use our feature: