Hi folks. I have table: mysql> describe gosc; +-------------+---------------------+------+-----+---------------------+---- ---+ | Field | Type | Null | Key | Default | Extra | +-------------+---------------------+------+-----+---------------------+---- ---+ | sesja | varchar(32) binary | | PRI | | | | host | varchar(80) | YES | MUL | NULL | | | data_wej | datetime | | MUL | 0000-00-00 00:00:00 | | | browser | varchar(100) | YES | | NULL | | | last_action | datetime | | MUL | 0000-00-00 00:00:00 | | | id_pory1 | int(3) unsigned | YES | | NULL | | | id_pory2 | int(3) unsigned | YES | | NULL | | | nr_ip | varchar(15) | YES | | NULL | | | id_user | bigint(12) unsigned | | MUL | 0 | | | user_log | varchar(150) | | | 0- | | +-------------+---------------------+------+-----+---------------------+---- ---+ 10 rows in set (1.39 sec)
I made: mysql> explain select sesja,data_wej,id_user,user_log,nr_ip from gosc where date_add(last_action, interval 5 minute) > now(); +-------+------+---------------+------+---------+------+-------+------------ + | table | type | possible_keys | key | key_len | ref | rows | Extra | +-------+------+---------------+------+---------+------+-------+------------ + | gosc | ALL | NULL | NULL | NULL | NULL | 37803 | where used | +-------+------+---------------+------+---------+------+-------+------------ + Is my table good indexed ?? Or maybe this query above can be faster ?? Regards Ireneusz Piasecki -- Okresl Swoje potrzeby - my znajdziemy oferte za Ciebie! [ http://oferty.onet.pl ] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
