Best MySQL plugin? - Printable Version

Best MySQL plugin? - 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: Best MySQL plugin? (/showthread.php?tid=490885)

Best MySQL plugin? - CH | FuDo - 28.01.2014

Okay, title of topic says everything. Which MySQL plugin is best to use? Thank you.

Re: Best MySQL plugin? - ikey07 - 28.01.2014

This one:
https://sampforum.blast.hk/showthread.php?tid=122983

Also it has Static Linux Distributions versions, which make it easier to use, many will suggest you BlueG's plugin, but I dont find it usleful.

Re: Best MySQL plugin? - maddinat0r - 28.01.2014

BlueG's MySQL plugin of course. The support is good, there is a good documentation about every function and it's actively developed.

Re: Best MySQL plugin? - Jimmy0wns - 28.01.2014

Strickenkid, the fastest one.

Re: Best MySQL plugin? - Konstantinos - 28.01.2014

Quote:

Originally Posted by Jimmy0wns

Strickenkid, the fastest one.

Don't say things you cannot prove. Strickenkid's plugin is very old and slow, it's not recommended at all.

Re: Best MySQL plugin? - Scenario - 28.01.2014

BlueG's. Strickenkid's plugin hasn't been updated in YEARS, it's outdated and slow.

Re: Best MySQL plugin? - CH | FuDo - 28.01.2014

Well, I use Blue-G but when I upload on my Linux server, I got this error

Код:

  Loading plugin: mysql.so
[20:28:57]   Failed (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory)

How to fix this? Thank you!

Re: Best MySQL plugin? - maddinat0r - 28.01.2014

Quote:

Originally Posted by CH | FuDo

Well, I use Blue-G but when I upload on my Linux server, I got this error

Код:

  Loading plugin: mysql.so
[20:28:57]   Failed (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory)

How to fix this? Thank you!

Use the mysql_static.so.

EDIT:

Quote:

Originally Posted by Jimmy0wns

Strickenkid, the fastest one.

I made a benchmark:

Quote:

Sending 100 unthreaded queries (10000 rows per query) and fetching every field per index
Strickenkid's: 3300ms
BlueG's: 3100ms

So yeah, BlueG's plugin is still faster. I think I don't need to make a benchmark using threaded queries.

Re: Best MySQL plugin? - CH | FuDo - 28.01.2014

Quote:

Originally Posted by maddinat0r

Use the mysql_static.so.

Added to server.cfg on line plugins mysql_static.so
Still not working.. Any other help? Thank you.

Re: Best MySQL plugin? - maddinat0r - 28.01.2014

Quote:

Originally Posted by CH | FuDo

Added to server.cfg on line plugins mysql_static.so
Still not working.. Any other help? Thank you.

What do you mean with "still not working"? I can't help you without getting at least an error message.
It's also impossible that the mysql_static.so generates the same error message you had before, so don't answer like "the error is the same".