[iFarrow]

Could someone give me a couple of functions to save and load data in mysql and where to put them.

[admantis]

This is a very broad question... please read MySQL documentation (on it's website and on the main plugin thread) and read example scripts to understand how it works.

[iFarrow]

Quote:

Originally Posted by admantis This is a very broad question... please read MySQL documentation (on it's website and on the main plugin thread) and read example scripts to understand how it works.

I have but I don't know which methods work better.

[Scenario]

Download one of the various base-MySQL scripts available.

[admantis]

Quote:

Originally Posted by iFarrow I have but I don't know which methods work better.

Generally the "faster" method is using cache, this is available in every MySQL plugin apart from StrickenKid's and allows you to create threaded queries. PAWN is single-threaded, so every function is on a "queue" and one thing gets called at a time. If you have threaded queries, they will be executed in a separate background. This is why they are faster and more efficient.

AndreT wrote a very good tutorial explaining cache and threaded queries too, read it and try to puzzle it out!