Please explain me why this is taking so long.

  • Filter
  • Time
  • Show
Clear All
new posts

  • #16
    Yes , the username is unique and is marked as being an index .
    Also i have another index on status .
    That's because there are few times when i use the username/status together to obtain some data, i mean i use status when i check for accounts to be activated , in the rest i use the username to obtain the user_id(bc i have a site having the url's like www.site.com/username.html ).
    I did some tests with an index on username/status then erase it and made an index on username and another one on status and these one was faster than the first one .