caching - Should stored procedure cached in Mysql -


should stored procedure cached in mysql? if yes, how long stay in cache?

in case, when call 1 stored procedure first time, giving me result in 1sec, after gives me result in 400ms. , when changing parameters passed stored procedure , call first time, same behavior performed. so, can not understand happening? can 1 guide me?

thanks.

this normal behavior of system uses cache :

  • at first time execution results loaded in cache , small overhead appears
  • the following execution take less because in cache but if input changed (like in case : changing parameters of stored procedure) results in cache not longer viable new results (using changed inputs) must put in cache why takes longer

you can read more here


Comments

Post a Comment

Popular posts from this blog

c# - Operator '==' incompatible with operand types 'Guid' and 'Guid' using DynamicExpression.ParseLambda<T, bool> -

i'm using dynamic linq library , there source code , basic docu , nuget version pm> install-package dynamiclinq i'm trying construct clause involves guids i have tried string "id == @0" . parameter array object[] value ( guid xxxx ) var whereclausesb = buildlogicalkeywhereclause2(entity, logicalkey); //build string var parms = buildparamarray(entity, logicalkey); // object[] var wherelambda = ofsi.bos.core.dynamicexpression.parselambda<t, bool>(whereclausesb.tostring(),parms); //parse an exception thrown in dynamicexpression.parselambda operator '==' incompatible operand types 'guid' , 'guid' i have tried guid , string.(fail) i tried , "id = @0" (fail). string == string works, int32==int32 not guid == guid not any ideas? try using equals method instead of == operator in string: "id.equals(@0)"
Read more