Profiles Schema Performance Considerations

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

If the Commerce Server Membership Provider does not find the required properties in the SQL Server database, performance can be negatively impacted. Therefore, it is better not to delete the required profiles properties. These profiles properties are required:

  • Comment (GeneralInfo.comment)

  • CreationDate (ProfileSystem.date_created)

  • Email (GeneralInfo.email_address)

  • IsLockedOut (ProfileSystem.logon_error_dates, ProfileSystem.password_answer_error_dates, ProfileSystem.last_lockedout_date)

  • LastLockoutDate (ProfileSystem.logon_error_dates, ProfileSystem.password_answer_error_dates, ProfileSystem.last_lockedout_date)

  • LastActivityDate (ProfileSystem.last_activity_date)

  • LastLoginDate (ProfileSystem.date_last_logon)

  • LastPasswordChangedDate (ProfileSystem.date_last_password_changed)

  • PasswordQuestion (GeneralInfo.password_question, GeneralInfo.password_answer)

See Also

Other Resources

Profiles Schema

What Is the Commerce Server Membership Provider?

How to Enable Logons by Using the Commerce Server Membership Provider