[Dan..]

Quote:

Originally Posted by Pain123 A feature comparison: I think your plugin also uses multi-threading, but only with 2+ connections. Speed tests: Your plugin doesn't work on my Linux machine, it says some "clock_gettime" function or something is missing.

+ y_inline support - I didn't have any plans on implementing it, but now that you mention, it's there.
- visual logging (HTML log) - Yeah sure, because a pile of shit (HTML tags) is always better. Let's also take into consideration that there are many browsers that can open a .HTML file that's over 100mbs.
- multi-threading - I lol'd in real life when I read this. The way I handle multi-threading is the real way. Your plugin fetches malformed results. Anyway, you can manually implement a pool in Pawn or wait for me to do it in v2.7.
? ORM-like system (R33+) - proof or gtfo :hurr:
+ unthreaded queries - People don't have to put much effort to convert their old scripts and get rid of bugs. In some cases (especially in OnGameModeInit and OnGameModeExit) unthreaded queries are required.
+ PostgreSQL support - Cool or what?
+ striking resemblance with SQLite api - It comes in handy for users that want to convert their old scripts.
+ multiple result sets
+ proper result handling
+ "live" (a.k.a. non-cached) queries - Especially when a large amount of data has to be loaded.
+ parameters can be pushed by reference - Great, ain't it?
+ many more that I'm not bothered to post

Your plugin might be faster (I still don't believe your results), but mine offers reliability.

P.S. I fixed that clock_gettime() issue. Thanks for the report!

I also did a quich benchmark, output:

Code:

GO!!! (Dan)      | now = 45693129 (start)
connected        | now = 45693134 | now - last =     5 | now - start =     5
scheduled        | now = 45693136 | now - last =     2 | now - start =     7
done             | now = 45693137 | now - last =     1 | now - start =     8
executed         | now = 45702784 | now - last =  9647 | now - start =  9655
----------------------------------------------------------------------------
GO!!! (BlueG)    | now = 45729908 (start)
connected        | now = 45729913 | now - last =     5 | now - start =     5
scheduled        | now = 45729915 | now - last =     2 | now - start =     7
done             | now = 45729919 | now - last =     4 | now - start =    11
executed         | now = 45742206 | now - last = 12287 | now - start = 12298

Quote:

Originally Posted by BlackBank3 The plugin is loading correctly now, but if i use one of the functions in my gamemode, my server crash immediately.

Check the latest version.

Quote:

Originally Posted by Avenger™ Still like blueg's

What?

Quote:

Originally Posted by HitnKill Wow this plugin it's very interesting because i have MYSQL R6 and it's too long to update on R7 or more with my all query SELECT The Query non threaded and cached is more fast than MYSQL R6 ? I can have more example querys non threaded and cached? PHP Code: new Result:vehicles = sql_query(conn, "SELECT * FROM vehicles", QUERY_CACHED);     //          using cache, even though this is a non-threaded query ^      //          awesome or what?     for (new i = 0, rows = sql_num_rows(vehicles); i != rows; ++i) {         new vehicle[eVehicle];         vehicle[vId] = sql_get_field_assoc_int(vehicles, "id");         vehicle[vModelID] = sql_get_field_assoc_int(vehicles, "modelid");         vehicle[vColor1] = sql_get_field_assoc_int(vehicles, "color1");         vehicle[vColor2] = sql_get_field_assoc_int(vehicles, "color2");         vehicle[vPos][0] = sql_get_field_assoc_float(vehicles, "pos_x");         vehicle[vPos][1] = sql_get_field_assoc_float(vehicles, "pos_y");         vehicle[vPos][2] = sql_get_field_assoc_float(vehicles, "pos_z");         vehicle[vPos][3] = sql_get_field_assoc_float(vehicles, "rot");         sql_next_row(vehicles);                  }                sql_free_result(vehicles);  What is PHP Code: sql_next_row(vehicles);

Yes it is faster.
sql_next_row retrieves the next row.

For those who haven't noticed, I created a FAQ page on Github's Wiki.