2.8.4

Database feature : INDEX field.Database Index Field

In order to optimise your queries, you can set some important fields as index. It means that they will be stored in an index table for searching faster on it.
For instance, if you store a list of products codes, define the code field as INDEX it will be faster to search on it.
An index field becomes automatically unique

For starters it's just so easy to design an app in a way that I'm used to i.e. database first then views followed by customization. The fork system is pure brilliance from a developer standpoint as I can override things and still add and update my projects with minimal effort! Truly amazing to be able to build components in Joomla using incremental refinement without having to do everything by hand. Thanks for the great tool! I am so much more productive now than ever and I can't imagine building components any other way!!!!
Dave (Forum)

Get Started