In reply to Sorry Alex
You understanding of SQL is wrong ! If search field is indexed then MySQL do not examine rows at all, it get it directly, because it is indexed.

"SELECT *" is used in places where most of the fields are user or may be used - also it is not related to the query execution speed.

Also profiles are cached and once cached no access to database is performed to get particular profile info.
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.