Hi, My name is nitroburn. My Tikiwiki homepage is @ Corrupt Logic
After playing around I have replaced all the database "select" commands in the libraries to "select SQL_CACHE" this (if your mysql is setup to) will use caching for all database requests. So far, this has lead to a small jump in speed. I haven't found it to break anything yet... I deleted everything and redownloaded the CVS 1.9 ... NOTE! Some things really are broken in the 1.9cvs at the moment. I did all the replacing this time with ... replace /usr/local/bin/replace -fsrv "'SELECT" "'SELECT SQL_CACHE"
ran both those and it replaced everything with no breakage!
Odd.. repaced libraries with CVS lib's and seems to be only a few ms slower now. Damn weird results.
As per the comment by damian.. a single replace can be done in tikidblib.php function convert_query(&$query) {
-- question.. is str_replace case sensitive? |