[RESOLVED] Eficiency when using same query multiple times

[itaym02]

Greetings,
Mysql v4.1

I have a query, which I use lots of times. This query is used as a view i.e. it's results are a view for other queries.
When I use the following syntax:

SELECT
FROM (SELECT FROM ff,gg,dfd WHERE I=g and h=k and l=e)

(and I use it multiplied...)

So - When I use this syntax - it is a lot slower from the next example:

CREATE TABLE temp AS (SELECT * FROM ff,gg,dfd WHERE I=g and h=k and l=e);

SELECT * FROM temp;

From that I deduce that the results of the quert, I use as view, are not chached.
Is there a way to make Mysql Cach the results of a query?

[cahva]

Yes. By default cache size is 0(off). You can change it to your mysql settings(example my.cnf).
Add atleast this line to it:
query_cache_size= 16M

Then restart the server.

Size is depending how large your queries normally are. That size is good for our server and speeds up queries quite nicely.

[itaym02]

Thanks!

Will check it right away.

[Roger_Ramjet]

You should also consider using SQL_NO_CACHE on all the other queries so that the one you want cached does not get flushed to make space for them.

[itaym02]

thanks