[CH | FuDo]

Hi guys, I'm thinking about scripting using MySQL. What do you recommend to me? Threaded queries or not? BlueG plugin or some other? If BlueG plugin, which one r5, r6, r7?

Thank you.

[PowerPC603]

R5-R7 are old versions.
Use the latest BlueG's plugin: R37.

You could use non-threaded queries to load certain data before your server is opened to the public.
Vehicle-data, mission-data, house-data and such things should be loaded before the server is open, for such things you can use non-threaded queries (mysql_query).

Once the server is running, use threaded queries for everything else as you don't want lag because some query might block further execution of your script while waiting for MySQL to process the query.
Loading player-accounts, updating their cash and score, ... should be done using threaded queries.

[RajatPawar]

I'd suggest directly using the R7 version, after learning the basic MySQL required for SA-MP servers and after reading this tutorial.

The latest version of MySQL have ORM and some stuff, that IMHO is a load of tosh - it simply isn't required. Threaded queries (R7+) are efficient, they work, they are easy to use and they give you what you want. Simple enough already.

Happy learning!

[M3HR4N]

Start with R6 if you are too newbie on mysql.

[CH | FuDo]

I'll try with BlueG r37, thank you for responses.