hi guys,
we have problem @ xampp' s mysql. we have 250k rows @ mysql. we r starting a query like below and query turning at 10 sec or more. do u have any suggestion? thx...
select PROTOCOL,DEST_PORT,count(ID) as c from ip_port_protocol Where DATE(CREATION_DATE) between ADDDATE(DATE(NOW()),interval -1 month) and DATE(NOW()) Group By ip_port_protocol.PROTOCOL,DEST_PORT Order BY COUNT(ID) desc LIMIT 0, 5