Hi, i need some help, since mysql benchmark don't work well on select i need help with a query
what will be the fastest way? to use this query:
select * from news n, users u where n.users_id = u.users_id and u.users_id = '1' limit 0, 20
using like this is pretty slow (table are indexed, over 1 billion records)
My question is: if i put this query in a stored procedure and then call it
call showNews(userx)
will be faster? and use lower cpu resources?
Thanks