[Plugin] MySQL & PostgreSQL Plugin

Linear Mode

[Plugin] MySQL & PostgreSQL Plugin

~~maddinat0r~~
Banned

Posts: 845
Threads: 3
Joined: Jun 2010

#126

27.07.2013, 11:29

Quote:

Originally Posted by Dan..

[...]I've done some more tests and it looks like this is still the fastest and most feature-rich plugin out.

A feature comparison:

Quote:

BlueG's:
- y_inline support
- visual logging (HTML log)
- multi-threading
- ORM-like system (R33+)

Dan's:
- unthreaded queries
- PostgreSQL support

I think your plugin also uses multi-threading, but only with 2+ connections.

Speed tests:

Quote:

Windows (4x3.4GHz, logging disabled)
-------
Only executing queries:
v2.0: 3186 ms
v2.4: 2404 ms

R25: 3396 ms
R26: 3152 ms
R27: 3057 ms
R28: 2609 ms
R33: 1752 ms //not sure about this result

Getting data with field names (sql_get_field_assoc/cache_get_field_content) + _int & _float versions:
v2.0: 9902 ms
v2.4: 6610 ms

R25: 9562 ms
R26: 6722 ms
R27: 5595 ms
R28: 6544 ms
R33: 5447 ms

Getting data with field indices (sql_get_field/cache_get_row) + _int & _float versions:
v2.0: 7191 ms
v2.4: 4597 ms

R25: 6127 ms
R26: 4739 ms
R27: 3717 ms
R28: 3706 ms
R33: 3358 ms

Your plugin doesn't work on my Linux machine, it says some "clock_gettime" function or something is missing.

Find

Reply

« Next Oldest | Next Newest »

Messages In This Thread

MySQL & PostgreSQL Plugin - by Dan.. - 09.04.2013, 19:38

Re: MySQL Plugin v0.1 BETA - by Djole1337 - 09.04.2013, 19:39

Re: MySQL Plugin v0.1 BETA - by Maxips2 - 09.04.2013, 19:54

Re: MySQL Plugin v0.1 BETA - by Djole1337 - 09.04.2013, 19:56

Re: MySQL Plugin v0.1 BETA - by steki. - 09.04.2013, 20:01

Re: MySQL Plugin v0.1 BETA - by Dan.. - 09.04.2013, 20:07

Re: MySQL Plugin v0.1 BETA - by Maxips2 - 09.04.2013, 20:15

Re: MySQL Plugin v0.1 BETA - by Scenario - 09.04.2013, 20:21

Re: MySQL Plugin v0.1 BETA - by Dan.. - 09.04.2013, 20:39

Re: MySQL Plugin v0.1 BETA - by Kar - 09.04.2013, 21:03

Re: MySQL Plugin v0.1 BETA - by Dan.. - 09.04.2013, 21:17

Re: MySQL Plugin v0.1 BETA - by Scenario - 09.04.2013, 21:27

Re: MySQL Plugin v0.1 BETA - by Dan.. - 09.04.2013, 21:30

Re: MySQL Plugin v0.1 BETA - by RedCrossER - 09.04.2013, 21:37

Re: MySQL Plugin v0.1 BETA - by BlueG - 09.04.2013, 22:03

Re: MySQL Plugin v0.1 BETA - by Kar - 10.04.2013, 00:06

Re: MySQL Plugin v0.1 BETA - by Dan.. - 10.04.2013, 07:52

Re: MySQL Plugin v0.1 BETA - by Dan.. - 10.04.2013, 12:34

Re: MySQL Plugin v0.1 BETA - by Ernis456 - 10.04.2013, 13:08

Re: MySQL Plugin v0.1 BETA - by Dan.. - 10.04.2013, 15:06

Re: MySQL Plugin v0.1 BETA - by Edvin - 10.04.2013, 16:13

Re: MySQL Plugin v0.1 BETA - by Maxips2 - 10.04.2013, 16:18

Re: MySQL Plugin v0.1 BETA - by Dan.. - 10.04.2013, 16:48

Re: MySQL Plugin v0.1 BETA - by Maxips2 - 10.04.2013, 16:52

Re: MySQL Plugin v0.1 BETA - by Jay_ - 10.04.2013, 17:43

Re: MySQL Plugin v0.1 BETA - by Kar - 10.04.2013, 18:16

Re: MySQL Plugin v0.1 BETA - by TheArcher - 10.04.2013, 18:25

Re: MySQL Plugin v0.1 BETA - by Maxips2 - 10.04.2013, 18:28

Re: MySQL Plugin v0.1 BETA - by AndreT - 10.04.2013, 18:34

Re: MySQL Plugin v0.1 BETA - by Jay_ - 10.04.2013, 18:42

Re: MySQL Plugin v0.1 BETA - by TheSka - 11.04.2013, 08:06

Re: MySQL Plugin v0.1 BETA - by Dan.. - 11.04.2013, 08:24

Re: MySQL Plugin v0.1 BETA - by TheSka - 11.04.2013, 08:46

Re: MySQL Plugin v0.1 BETA - by RajatPawar - 11.04.2013, 08:53

Re: MySQL Plugin v0.1 BETA - by MP2 - 11.04.2013, 09:27

Re: MySQL Plugin v0.1 BETA - by Dan.. - 11.04.2013, 10:43

Re: MySQL Plugin - by dnee - 12.04.2013, 01:05

Re: MySQL Plugin - by Dan.. - 12.04.2013, 11:59

Re: MySQL Plugin - by dnee - 12.04.2013, 15:02

Re: MySQL Plugin - by dnee - 12.04.2013, 15:08

Re: MySQL Plugin - by Dan.. - 12.04.2013, 16:44

Re: MySQL Plugin - by dnee - 12.04.2013, 16:57

Re: MySQL Plugin - by BrandyPenguin - 12.04.2013, 17:03

Re: MySQL Plugin - by dnee - 12.04.2013, 17:06

Re: MySQL Plugin - by BrandyPenguin - 12.04.2013, 17:13

Re: MySQL Plugin - by Dan.. - 12.04.2013, 18:13

Re: MySQL Plugin - by Dzines4SAMP - 20.04.2013, 03:21

Re: MySQL Plugin - by Dan.. - 23.04.2013, 15:10

Re: MySQL Plugin - by Gigi-The-Beast - 23.04.2013, 17:58

Re: MySQL Plugin - by Dan.. - 23.04.2013, 18:09

Re: MySQL Plugin - by Richard_Gere - 24.04.2013, 12:45

Re: MySQL Plugin - by Dan.. - 25.04.2013, 12:01

Re: MySQL Plugin - by Yiin - 07.05.2013, 11:12

Re: MySQL Plugin - by Dan.. - 07.05.2013, 11:52

Re: MySQL Plugin - by Richard_Gere - 07.05.2013, 12:13

Re: MySQL Plugin - by Ricop522 - 07.05.2013, 22:30

Re: MySQL Plugin - by Ryan_Obeles - 08.05.2013, 02:11

Re: MySQL Plugin - by Dan.. - 10.05.2013, 06:47

Re: MySQL Plugin - by Ryan_Obeles - 10.05.2013, 16:10

Re: MySQL Plugin - by Dan.. - 10.05.2013, 21:15

Re: MySQL Plugin - by Dan.. - 12.05.2013, 19:08

Re: MySQL Plugin - by Dan.. - 13.05.2013, 12:32

Re: MySQL Plugin - by Dan.. - 13.05.2013, 15:47

Re: MySQL Plugin - by Dan.. - 13.05.2013, 16:43

Re: MySQL Plugin v1.0 STABLE - by jordy.kiesebrink - 13.05.2013, 19:00

AW: MySQL Plugin - by AlexLS95 - 13.05.2013, 19:30

Re: AW: MySQL Plugin - by jordy.kiesebrink - 13.05.2013, 20:09

Re: MySQL Plugin - by Dan.. - 14.05.2013, 19:30

Re: MySQL Plugin - by Gamer_Z - 14.05.2013, 19:37

Re: MySQL Plugin - by Gamer_Z - 14.05.2013, 19:43

Re: MySQL Plugin - by Dan.. - 14.05.2013, 19:46

Re: MySQL Plugin - by Gamer_Z - 14.05.2013, 19:49

Re: MySQL Plugin - by jordy.kiesebrink - 14.05.2013, 20:20

Re: MySQL Plugin - by Dan.. - 15.05.2013, 10:23

Re: MySQL Plugin - by Edvin - 16.05.2013, 13:00

Re: MySQL Plugin - by InfiniTy. - 16.05.2013, 13:06

Re: MySQL Plugin - by Dan.. - 16.05.2013, 13:08

Re: MySQL Plugin - by fordawinzz - 18.05.2013, 13:23

Re: MySQL Plugin - by Dan.. - 18.05.2013, 14:06

Re: MySQL Plugin - by fordawinzz - 18.05.2013, 14:14

Re: MySQL Plugin - by Dan.. - 18.05.2013, 14:18

Re: MySQL Plugin - by fordawinzz - 18.05.2013, 14:35

AW: Re: MySQL Plugin - by maddinat0r - 22.05.2013, 16:31

Re: MySQL Plugin - by Dan.. - 22.05.2013, 16:38

Re: MySQL Plugin - by Dan.. - 02.06.2013, 12:51

Re: MySQL Plugin - by Kar - 02.06.2013, 14:44

Re: MySQL Plugin - by Kyle - 02.06.2013, 14:45

Re: MySQL Plugin - by Dan.. - 02.06.2013, 14:52

Re: MySQL Plugin - by Kar - 02.06.2013, 14:53

Re: MySQL Plugin - by Schocc - 02.06.2013, 17:16

Re: MySQL Plugin - by Richie© - 02.06.2013, 18:24

Re: MySQL Plugin - by TheArcher - 02.06.2013, 19:33

Re: MySQL Plugin - by AndreT - 02.06.2013, 20:32

Re: MySQL Plugin - by Baboon - 02.06.2013, 20:54

Re: MySQL & PostgreSQL Plugin - by Dan.. - 27.06.2013, 08:38

AW: MySQL & PostgreSQL Plugin - by maddinat0r - 27.06.2013, 08:40

Re: MySQL & PostgreSQL Plugin - by Slice - 27.06.2013, 09:01

Re: MySQL & PostgreSQL Plugin - by AndreT - 27.06.2013, 12:05

Re: MySQL & PostgreSQL Plugin - by yanir3 - 27.06.2013, 12:47

Re: MySQL & PostgreSQL Plugin - by Dan.. - 27.06.2013, 12:57

Re: MySQL & PostgreSQL Plugin - by AndreT - 27.06.2013, 13:24

Re: MySQL & PostgreSQL Plugin - by Dan.. - 27.06.2013, 14:36

Re: MySQL & PostgreSQL Plugin - by CKA3KuH - 28.06.2013, 13:56

Re: MySQL & PostgreSQL Plugin - by Dan.. - 28.06.2013, 14:03

Respuesta: MySQL & PostgreSQL Plugin - by [DOG]irinel1996 - 28.06.2013, 15:08

Re: MySQL & PostgreSQL Plugin - by AndreT - 28.06.2013, 20:40

Re: MySQL & PostgreSQL Plugin - by Richard_Gere - 29.06.2013, 07:00

Re: MySQL & PostgreSQL Plugin - by Dan.. - 29.06.2013, 19:58

Re: MySQL & PostgreSQL Plugin - by Richard_Gere - 30.06.2013, 04:09

Re: MySQL & PostgreSQL Plugin - by Dan.. - 30.06.2013, 10:22

Re: MySQL & PostgreSQL Plugin - by Ryan_Bowe - 30.06.2013, 23:46

Re: MySQL & PostgreSQL Plugin - by gilpenner - 01.07.2013, 05:57

Re: MySQL & PostgreSQL Plugin - by Jessyy - 02.07.2013, 21:51

Re: MySQL & PostgreSQL Plugin - by Pooh7 - 03.07.2013, 17:09

AW: MySQL & PostgreSQL Plugin - by Nanory - 22.07.2013, 17:06

Re: MySQL & PostgreSQL Plugin - by Kar - 22.07.2013, 17:21

AW: MySQL & PostgreSQL Plugin - by Nanory - 22.07.2013, 17:32

Re: AW: MySQL & PostgreSQL Plugin - by BlackBank - 22.07.2013, 18:24

AW: MySQL & PostgreSQL Plugin - by Nanory - 22.07.2013, 18:51

Re: MySQL & PostgreSQL Plugin - by RaZVaN ^ xD - 22.07.2013, 21:45

AW: MySQL & PostgreSQL Plugin - by Nanory - 22.07.2013, 23:55

Re: AW: MySQL & PostgreSQL Plugin - by Maxips2 - 24.07.2013, 19:45

Re: MySQL & PostgreSQL Plugin - by Djole1337 - 24.07.2013, 19:55

Re: MySQL & PostgreSQL Plugin - by BlackBank - 26.07.2013, 13:31

Re: MySQL & PostgreSQL Plugin - by Dan.. - 27.07.2013, 07:59

AW: MySQL & PostgreSQL Plugin - by maddinat0r - 27.07.2013, 11:29

Re: MySQL & PostgreSQL Plugin - by BlackBank - 27.07.2013, 13:01

AW: MySQL & PostgreSQL Plugin - by AlexLS95 - 27.07.2013, 13:08

Re: AW: MySQL & PostgreSQL Plugin - by BlackBank - 27.07.2013, 13:15

AW: MySQL & PostgreSQL Plugin - by AlexLS95 - 27.07.2013, 19:49

Re : MySQL & PostgreSQL Plugin - by HitnKill - 28.07.2013, 13:56

Re: Re : MySQL & PostgreSQL Plugin - by Dan.. - 30.07.2013, 16:36

Re: MySQL & PostgreSQL Plugin - by Maxips2 - 30.07.2013, 17:28

Re: MySQL & PostgreSQL Plugin - by Dan.. - 30.07.2013, 17:41

Re: MySQL & PostgreSQL Plugin - by Gigi-The-Beast - 30.07.2013, 17:41

Re: MySQL & PostgreSQL Plugin - by Maxips2 - 30.07.2013, 17:42

Re: MySQL & PostgreSQL Plugin - by Dan.. - 30.07.2013, 17:48

Re: MySQL & PostgreSQL Plugin - by Kar - 30.07.2013, 20:18

Re: MySQL & PostgreSQL Plugin - by BlackBank - 30.07.2013, 22:53

Re: MySQL & PostgreSQL Plugin - by Dan.. - 31.07.2013, 05:03

Re: MySQL & PostgreSQL Plugin - by fordawinzz - 31.07.2013, 08:37

Re: MySQL & PostgreSQL Plugin - by Dan.. - 31.07.2013, 09:58

AW: Re: Re : MySQL & PostgreSQL Plugin - by maddinat0r - 31.07.2013, 11:02

Re: AW: Re: Re : MySQL & PostgreSQL Plugin - by Dan.. - 31.07.2013, 11:29

Re: MySQL & PostgreSQL Plugin - by d711728 - 07.02.2014, 22:45

Re: MySQL & PostgreSQL Plugin - by RoW001 - 12.02.2014, 10:24

AW: MySQL & PostgreSQL Plugin - by Mellnik - 12.02.2014, 13:01

Re: MySQL & PostgreSQL Plugin - by RoW001 - 13.02.2014, 09:45

Re: MySQL & PostgreSQL Plugin - by iZN - 13.02.2014, 10:52

Re: MySQL & PostgreSQL Plugin - by kristo - 16.02.2014, 11:04

Re: AW: MySQL & PostgreSQL Plugin - by AndreT - 16.02.2014, 13:09

Re: MySQL & PostgreSQL Plugin - by vent - 20.02.2014, 14:24

Re: MySQL & PostgreSQL Plugin - by OnPlayerText - 26.02.2014, 05:20

Re: MySQL & PostgreSQL Plugin - by Sagna - 27.02.2014, 16:19

Re: MySQL & PostgreSQL Plugin - by Quis - 07.03.2014, 20:22

Re : MySQL & PostgreSQL Plugin - by khimera - 09.09.2014, 01:41

Re: Re : MySQL & PostgreSQL Plugin - by Djole1337 - 29.09.2014, 12:43

Re: MySQL & PostgreSQL Plugin - by Ochenta - 10.10.2014, 17:24

Re: MySQL & PostgreSQL Plugin - by bogushas - 13.12.2014, 08:11

Re: MySQL & PostgreSQL Plugin - by CachorroDoDavyJones - 03.01.2015, 21:24

Re: MySQL & PostgreSQL Plugin - by Abagail - 03.01.2015, 21:32

Re: MySQL & PostgreSQL Plugin - by TheCartman - 20.01.2015, 08:55

Re: MySQL & PostgreSQL Plugin - by Djole1337 - 20.01.2015, 08:59

Re: MySQL & PostgreSQL Plugin - by TheCartman - 20.01.2015, 20:32

Re: MySQL & PostgreSQL Plugin - by Djole1337 - 21.01.2015, 00:55

Re: MySQL & PostgreSQL Plugin - by TheCartman - 21.01.2015, 18:45

Re: MySQL & PostgreSQL Plugin - by Anarkien - 28.01.2015, 17:30

Re: MySQL & PostgreSQL Plugin - by Blacklite - 08.05.2015, 09:46

AW: MySQL & PostgreSQL Plugin - by Akmet - 09.05.2015, 12:51

Re: MySQL & PostgreSQL Plugin - by Blacklite - 15.05.2015, 02:55

Re: MySQL & PostgreSQL Plugin - by Patrick - 03.08.2015, 10:21

Re: MySQL & PostgreSQL Plugin - by BlackBank - 03.08.2015, 17:03

Re: MySQL & PostgreSQL Plugin - by Djole1337 - 20.02.2017, 20:45

Re: MySQL & PostgreSQL Plugin - by Scriptery - 16.07.2017, 23:14

Re: MySQL & PostgreSQL Plugin - by Barnwell - 26.08.2017, 06:38

View a Printable Version

Forum Jump:

Users browsing this thread: 7 Guest(s)