CREATE TABLE users (
   login varchar( 32 ) NOT NULL,
   pass varchar( 32 ) NOT NULL,
   mail varchar( 128 ) NOT NULL,

   gender char( 1 ) NOT NULL,
   active char( 1 ) NOT NULL,
   logTime datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   regTime datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,

   photoHave int( 1 ) unsigned DEFAULT '0' NOT NULL,
   messNew int( 3 ) unsigned DEFAULT '0' NOT NULL,

   и.т.д еще  55  полей
   PRIMARY KEY (login),
   KEY mainSearch (gender, photoHave)
}

select login, pass where login AND pass
update (logTime)

$where_add = "active = 'Y' AND gender = 'F' AND photoHave != 0"

$sql = "SELECT COUNT(login) as numRows FROM users WHERE ".$where_add;
$numRows = mysql_result(mysql_query($sql),  0 ,  0 );

SELECT * FROM users WHERE ".$where_add." ORDER BY regTime DESC

CREATE TABLE usersSearch (
   login varchar( 32 ) NOT NULL,
   gender char( 1 ) NOT NULL,
   active char( 1 ) NOT NULL,
   photoHave int( 1 ) unsigned DEFAULT '0' NOT NULL,
   regTime datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
}

CREATE TABLE usersLogin (
   login varchar( 32 ) NOT NULL,
   pass varchar( 32 ) NOT NULL,
   messNew int( 3 ) unsigned DEFAULT '0' NOT NULL,
   logTime datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
}

LOCKED UPDATE USERS
SENDING DATA SELECT

Sending Data для Select ов, до  10 - 15  секунд,

блокировок связанных с UPDATE таблицы USERS,