Re: MySQL cash optimization
> second time server can do it for 1min.
Caching.
> Is there any way to prevent from the mysql making this cashing?
To make repeat runs as slow as the first? Why would you wish to do that?
> Is there any way to do some changes for make it faster?
Let's see the results of Show Create Table for each table, and of Explain Extended for each query.
Also, if these are InnoDB tables, what's innodb_buffer_pool_size, how much RAM is there?
> '.$id_cat.'
BTW, what API language wants dots surrounding var refs?
Subject
Views
Written By
Posted
2546
November 27, 2014 06:33AM
Re: MySQL cash optimization
1518
November 27, 2014 04:34PM
1198
December 09, 2014 04:33AM
1063
December 09, 2014 12:28PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.