Caching mysql table for performance -

in page, have multiple queries fetch data same table different scenarios. these multiple queries give me performance issues. trying cache table , query different scenarios , in way don't need hit database time.

but, don't know how cache table , query it.

can help?

is there other way improve performance?

caching table easy: select * mytable, , read data array. you'll have search in choice of language. small table , simple queries faster. large table run memory problems, , complex queries become more difficult.

there many potential ways improve performance. adding indexes appropriate columns can make world of difference, can exact order in perform queries , subqueries. without idea of schema you're using, or the queries you're applying it's impossible more.