SA-MP Forums Archive
[BlueG's MYSQL] Question - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: [BlueG's MYSQL] Question (/showthread.php?tid=614738)



[BlueG's MYSQL] Question - PRoleplay - 12.08.2016

so Iam using cache_get_field_content to get the field value

my question is do i need to mysql_free_result on the bottom of the code ? to trash all cache?
or in cache_get_field_content it will automatically?

thanks Im worrying for some too many cache that may cause to lag my server


Re: [BlueG's MYSQL] Question - Gammix - 12.08.2016

If you are using mysql_query, you have to use cache_delete, but if you are using threaded queries, then cache is not saved but passed into a callback, so no need in that case.


Re: [BlueG's MYSQL] Question - PRoleplay - 12.08.2016

iam using this mysql_function_query function sir

Thanks for response really appreciate


Re: [BlueG's MYSQL] Question - Gammix - 12.08.2016

Why aren't you using MySQL r39+ ?

R7 i guess do not support threaded queries, and threaded queries are most important in terms or reading data.


Re: [BlueG's MYSQL] Question - Vince - 12.08.2016

Yeah it does, but in a rather limited way. But I believe cache_* functions were only added in R33 so somewhere there is a mismatch.