[Tutorial] Using BlueG's MySQL plugin R7 (with cache)
#9

Nothing is forcing people to update to the new "method", as threaded queries from R6/R6-2 work perfectly. But there are a few cases when scripters should:
1. When they want to organize their code structure better (example: move minigame query results to the minigame block of the code instead of having it in OnQueryFinish),
2. When they need to pass extra parameters to the query finishing callback and the playerid and extraid parameter of OnQueryFinish won't do (or even worse if you use PVars, GVars or even arrays to store this information),
3. When dealing with rather large sets of data and/or more than 1 row of data (in such cases, the caching is notably faster as mentioned in the previous posts).

Any more questions/ideas/suggestions/requests, let me know!
Reply


Messages In This Thread
Using BlueG's MySQL plugin R7 and newer (with cache) - by AndreT - 27.04.2012, 22:55
Re: Using BlueG's MySQL plugin R7 (with cache) - by Ricop522 - 28.04.2012, 05:01
Re: Using BlueG's MySQL plugin R7 (with cache) - by Niko_boy - 28.04.2012, 05:04
Respuesta: Using BlueG's MySQL plugin R7 (with cache) - by [Vector] - 28.04.2012, 05:36
Re: Using BlueG's MySQL plugin R7 (with cache) - by Burridge - 28.04.2012, 08:31
Re: Respuesta: Using BlueG's MySQL plugin R7 (with cache) - by AndreT - 28.04.2012, 08:51
Re: Using BlueG's MySQL plugin R7 (with cache) - by Lorenc_ - 28.04.2012, 09:39
Respuesta: Using BlueG's MySQL plugin R7 (with cache) - by [Vector] - 30.04.2012, 19:20
Re: Using BlueG's MySQL plugin R7 (with cache) - by AndreT - 30.04.2012, 20:03
Re: Using BlueG's MySQL plugin R7 (with cache) - by MP2 - 18.05.2012, 16:50
Re: Using BlueG's MySQL plugin R7 (with cache) - by kikito - 18.05.2012, 16:51
Re: Using BlueG's MySQL plugin R7 (with cache) - by AndreT - 18.05.2012, 19:29
Re: Using BlueG's MySQL plugin R7 (with cache) - by MP2 - 18.05.2012, 19:44
Re: Using BlueG's MySQL plugin R7 (with cache) - by AndreT - 18.05.2012, 19:51
Re: Using BlueG's MySQL plugin R7 (with cache) - by MP2 - 18.05.2012, 20:03
Re: Using BlueG's MySQL plugin R7 (with cache) - by AndreT - 18.05.2012, 20:37
Re: Using BlueG's MySQL plugin R7 (with cache) - by MP2 - 18.05.2012, 21:42
Re: Using BlueG's MySQL plugin R7 (with cache) - by AndreT - 19.05.2012, 08:18
Re: Using BlueG's MySQL plugin R7 (with cache) - by MP2 - 19.05.2012, 12:04
Re: Using BlueG's MySQL plugin R7 (with cache) - by Hiddos - 19.05.2012, 12:07
Re: Using BlueG's MySQL plugin R7 (with cache) - by Luis- - 20.05.2012, 00:29
Re : Using BlueG's MySQL plugin R7 (with cache) - by Vukilore - 21.05.2012, 16:28
Respuesta: Using BlueG's MySQL plugin R7 (with cache) - by Sauxe - 22.05.2012, 03:26
Re: Using BlueG's MySQL plugin R7 (with cache) - by TheArcher - 23.05.2012, 19:06
Re: Using BlueG's MySQL plugin R7 (with cache) - by AShop - 27.05.2012, 18:08
Re: Using BlueG's MySQL plugin R7 (with cache) - by Luis- - 27.05.2012, 18:19
Re: Using BlueG's MySQL plugin R7 (with cache) - by AndreT - 27.05.2012, 19:16
Re: Using BlueG's MySQL plugin R7 (with cache) - by ArchBishop - 27.05.2012, 20:25
Re: Using BlueG's MySQL plugin R7 (with cache) - by AndreT - 27.05.2012, 20:43
Re: Using BlueG's MySQL plugin R7 (with cache) - by ArchBishop - 28.05.2012, 20:21
AW: Re: Using BlueG's MySQL plugin R7 (with cache) - by Extremo - 11.06.2012, 07:01
Re: Using BlueG's MySQL plugin R7 (with cache) - by AndreT - 11.06.2012, 10:08
Re: Using BlueG's MySQL plugin R7 (with cache) - by Kyle - 11.06.2012, 11:08
Re: Using BlueG's MySQL plugin R7 (with cache) - by AndreT - 11.06.2012, 11:56
AW: Using BlueG's MySQL plugin R7 (with cache) - by Extremo - 11.06.2012, 12:18
Re: Using BlueG's MySQL plugin R7 (with cache) - by MP2 - 23.06.2012, 09:23
Re: Using BlueG's MySQL plugin R7 (with cache) - by Kyle - 23.06.2012, 10:13
Re: Using BlueG's MySQL plugin R7 (with cache) - by MP2 - 23.06.2012, 13:37
Re: Using BlueG's MySQL plugin R7 (with cache) - by Kyle - 23.06.2012, 13:40
AW: Using BlueG's MySQL plugin R7 (with cache) - by Cank - 23.06.2012, 14:02
Re: Using BlueG's MySQL plugin R7 (with cache) - by AndreT - 23.06.2012, 14:34
Re: Using BlueG's MySQL plugin R7 (with cache) - by SWEMike - 30.06.2012, 12:37
Re: Using BlueG's MySQL plugin R7 (with cache) - by AndreT - 30.06.2012, 20:21
Re: Using BlueG's MySQL plugin R7 (with cache) - by Splav - 02.07.2012, 13:10
Re: Using BlueG's MySQL plugin R7 (with cache) - by Coicatak - 10.07.2012, 12:08
Re : Using BlueG's MySQL plugin R7 (with cache) - by scott1 - 16.07.2012, 17:39
Re: Using BlueG's MySQL plugin R7 (with cache) - by AndreT - 17.07.2012, 20:28
Re : Using BlueG's MySQL plugin R7 (with cache) - by scott1 - 18.07.2012, 11:34
Re: Using BlueG's MySQL plugin R7 (with cache) - by Gumica - 22.07.2012, 12:35
Re: Re : Using BlueG's MySQL plugin R7 (with cache) - by AndreT - 27.07.2012, 10:19
Re: Using BlueG's MySQL plugin R7 (with cache) - by AndreT - 29.09.2012, 22:53
Re: Using BlueG's MySQL plugin R7 (with cache) - by Richie© - 03.10.2012, 21:08
Re: Using BlueG's MySQL plugin R7 (with cache) - by ReneG - 04.10.2012, 05:00
Re: Using BlueG's MySQL plugin R7 (with cache) - by Richie© - 04.10.2012, 20:54
Re: Using BlueG's MySQL plugin R7 (with cache) - by ScriptWriter - 12.10.2012, 15:56
Re: Using BlueG's MySQL plugin R7 (with cache) - by AndreT - 13.10.2012, 12:58
Re: Using BlueG's MySQL plugin R7 (with cache) - by ScriptWriter - 13.10.2012, 13:03
Re: Using BlueG's MySQL plugin R7 (with cache) - by AndreT - 13.10.2012, 13:05
Re: Using BlueG's MySQL plugin R7 (with cache) - by ScriptWriter - 13.10.2012, 13:15
Re: Using BlueG's MySQL plugin R7 (with cache) - by AndreT - 13.10.2012, 14:33
Re: Using BlueG's MySQL plugin R7 (with cache) - by ScriptWriter - 13.10.2012, 14:54
Re: Using BlueG's MySQL plugin R7 (with cache) - by AndreT - 13.10.2012, 15:04
Re: Using BlueG's MySQL plugin R7 (with cache) - by ScriptWriter - 01.11.2012, 07:58
Re: Using BlueG's MySQL plugin R7 (with cache) - by Edvin - 01.11.2012, 08:01
Re: Using BlueG's MySQL plugin R7 (with cache) - by ScriptWriter - 01.11.2012, 08:20
Re: Using BlueG's MySQL plugin R7 (with cache) - by IstuntmanI - 01.11.2012, 12:52
Re: Using BlueG's MySQL plugin R7 (with cache) - by ScriptWriter - 01.11.2012, 14:06
Re: Using BlueG's MySQL plugin R7 (with cache) - by IstuntmanI - 01.11.2012, 14:13
Re: Using BlueG's MySQL plugin R7 (with cache) - by ScriptWriter - 01.11.2012, 15:00
Re: Using BlueG's MySQL plugin R7 (with cache) - by ReneG - 01.11.2012, 16:09
Re: Using BlueG's MySQL plugin R7 (with cache) - by ReneG - 11.11.2012, 19:25
Re: Using BlueG's MySQL plugin R7 (with cache) - by AirKite - 11.11.2012, 20:05
Re: Using BlueG's MySQL plugin R7 (with cache) - by fordawinzz - 23.11.2012, 12:33
Re: Using BlueG's MySQL plugin R7 (with cache) - by AndreT - 23.11.2012, 13:50
Re: Using BlueG's MySQL plugin R7 (with cache) - by fordawinzz - 24.11.2012, 09:38
Re: Using BlueG's MySQL plugin R7 (with cache) - by AndreT - 24.11.2012, 11:20
Re: Using BlueG's MySQL plugin R7 (with cache) - by EterNo - 26.11.2012, 12:54
Re: Using BlueG's MySQL plugin R7 (with cache) - by EterNo - 26.11.2012, 18:28
Re: Using BlueG's MySQL plugin R7 (with cache) - by CoDeZ - 26.11.2012, 21:30
Re: Using BlueG's MySQL plugin R7 (with cache) - by Marusa - 03.12.2012, 18:26
Re: Using BlueG's MySQL plugin R7 (with cache) - by DaLgakıran - 30.05.2013, 14:01
Re: Using BlueG's MySQL plugin R7 (with cache) - by AndreT - 09.06.2013, 10:28
Re: Using BlueG's MySQL plugin R7 (with cache) - by Yashas - 21.07.2013, 08:56
Re: Using BlueG's MySQL plugin R7 (with cache) - by Richie© - 21.07.2013, 09:07
Re: Using BlueG's MySQL plugin R7 (with cache) - by Yashas - 21.07.2013, 09:21
Re: Using BlueG's MySQL plugin R7 (with cache) - by Richie© - 21.07.2013, 10:52
Re: Using BlueG's MySQL plugin R7 (with cache) - by Misiur - 21.07.2013, 10:57
Re: Using BlueG's MySQL plugin R7 (with cache) - by IstuntmanI - 21.07.2013, 11:14
Re: Using BlueG's MySQL plugin R7 (with cache) - by Grumbles - 28.07.2013, 23:46
Re: Using BlueG's MySQL plugin R7 (with cache) - by Luis- - 29.07.2013, 03:28
Re: Using BlueG's MySQL plugin R7 (with cache) - by Grumbles - 29.07.2013, 15:22
Re: Using BlueG's MySQL plugin R7 (with cache) - by Yashas - 30.07.2013, 03:07
Re: Using BlueG's MySQL plugin R7 (with cache) - by Michalec - 29.10.2013, 14:43
Re: Using BlueG's MySQL plugin R7 (with cache) - by gotwarzone - 12.11.2013, 08:50
Re : Using BlueG's MySQL plugin R7 (with cache) - by ombre - 11.01.2014, 13:35
Re: Using BlueG's MySQL plugin R7 (with cache) - by anou1 - 13.01.2014, 16:52
Re: Using BlueG's MySQL plugin R7 (with cache) - by dusk - 14.01.2014, 13:25
Re: Using BlueG's MySQL plugin R7 (with cache) - by KevinPRINCE - 22.02.2014, 20:51
Re: Using BlueG's MySQL plugin R7 (with cache) - by Guest4390857394857 - 20.03.2014, 08:03
Re: Using BlueG's MySQL plugin R7 (with cache) - by AiRaLoKa - 16.05.2014, 13:03
Re: Using BlueG's MySQL plugin R7 (with cache) - by ~Yoshi - 05.09.2015, 00:50
Re: Using BlueG's MySQL plugin R7 (with cache) - by AmigaBlizzard - 27.01.2016, 23:27
Re: Using BlueG's MySQL plugin R7 (with cache) - by maddinat0r - 29.01.2016, 13:07
Re: Using BlueG's MySQL plugin R7 (with cache) - by AmigaBlizzard - 07.02.2016, 12:05
Re: Using BlueG's MySQL plugin R7 (with cache) - by maddinat0r - 07.02.2016, 14:38
Re: Using BlueG's MySQL plugin R7 (with cache) - by AmigaBlizzard - 10.02.2016, 20:42
Re: Using BlueG's MySQL plugin R7 (with cache) - by Slawiii - 11.05.2016, 18:26
Re: Using BlueG's MySQL plugin R7 (with cache) - by thesuperuser - 13.05.2016, 12:36
Re: Using BlueG's MySQL plugin R7 (with cache) - by iSpy - 13.05.2016, 12:38

Forum Jump:


Users browsing this thread: 1 Guest(s)