[Release] vSql - MySQL Async Library

FiveM Resource Development & Modding Releases
,
65

hey dude, how can i get the query time in ms ? is there a good way ?

66

Use GetGameTimer. Record that before then after the query has completed then subtract the two.

67

Is this should work ? Or you’re talking about add timer in C# file ?
image

image
image847×115 5.89 KB

68

up is anyone has the answer ?

69

Hi, you can use sql_test from here as an example.

70

Thanks you my friend !

71

vSql 1.5.1

  • Improve mysql-async compatibility
  • Improve exception log format
  • Update MySqlConnector to 0.66.0

Binaries: https://github.com/warxander/vSql/releases/tag/v1.5.1

72

@Warxander hey man, appreciate your work, I am wondering if you have an implementation that I can use within my C# scripts directly, without using the exported methods?

EDIT: Figured it out, edited your source a little bit to my own needs. If anybody wants to know how, reply to my post I will post it then.

73

It would be a better idea to make a pull request, what do you think about it?

74

mysql-asnyc has been updated quite frequently in the past, @Warxander can you do another benchmark? Would be interesting to see if yours still performs better

75

I understand that but some sync feature actually important like inventory addon account. So is there anyways to convert Sync form to async form it always return a nil value so I don’t know what to do with that. Or there is nothing to do with that.

Here is the error that I don’t know about it.
Sorry for bad English

76

image
Could we get an updated Benchmark ? Thx

77

You can do it yourself because I was not able to run latest mysql-async on my machine.
I updated vSql benchmark results and benchmark itself.
Also, you will need to restart benchmark resource after launching server to start getting viable results.

1 Like
78

Okay, will do some test with Mysql-async 3.3.1 to see :slight_smile:

79

Mmh i tried everything, could not get the Benchmark working with MySQL
image

80

Maybe they changed interface somehow, idk.
My goal was to replace old MySQL.Async, because I don’t trust new one + it didn’t support transactions when I needed them.

81

Got it fixed, on transaction the second arg can not be nil with MySQL it has to be {}, running benchmark now

82

MySQL.Async 3.1.1
.transaction(ms) [ 96, 96, 97]
.execute (ms) [ 50, 50, 49]
.fetchScalar (ms) [ 51, 50, 51]
.fetchAll (ms) [ 50, 52, 52]

So a big improve, but transaction are still slower than vSql for sure !
( Running on my computer btw, idk if this got an positive or negative impact )

83

You should also test vSql on your PC for correct comparison.

84

will do later