MichaelM
Banned-
Posts
70 -
Joined
-
Last visited
-
Days Won
2 -
Feedback
0%
MichaelM last won the day on June 15 2017
MichaelM had the most liked content!
About MichaelM
Core X
-
BAN_NOTICE
Yes
Metin2 Dev
Informations
-
Gender
Male
Recent Profile Visitors
1196 profile views
MichaelM's Achievements
-
Type in your console: pkg install gmake
-
pkg install gmake
-
Contact me! Kind regards, Michael!
-
MySQL is sooo 2010's
MichaelM replied to Mind Rapist's topic in Paid Support / Searching / Recruiting
MySQL is owned by Oracle... so it's kinda the same thing... as long as we're not talking about some kind of enterprise engine -
Hey, you can use the same host for 2 servers as long as your servers aren't using the same ports.
-
MySQL is sooo 2010's
MichaelM replied to Mind Rapist's topic in Paid Support / Searching / Recruiting
________________________________________________ GOLANG with MySQL (engine = MyISAM) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ INSERT ------------------------------------------------ num of rows time taken ------------------------------------------------ 10 1.195444ms 100 6.075053ms 1000 47.439699ms 10000 483.999809ms 100000 4.707089053s 1000000 49.067407174s SELECT ------------------------------------------------ num of rows time taken ------------------------------------------------ 1000000 872.709µs SELECT & DISPLAY ------------------------------------------------ num of rows time taken ------------------------------------------------ 1000000 20.717354746s UPDATE ------------------------------------------------ num of rows time taken ------------------------------------------------ 1000000 2.309209968s 100000 257.411502ms 10000 26.73954ms 1000 3.483926ms 100 915.17µs 10 650.166µs DELETE ------------------------------------------------ num of rows time taken ------------------------------------------------ 1000000 6.065949ms ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ________________________________________________ GOLANG with MongoDB ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ INSERT ------------------------------------------------ num of rows time taken ------------------------------------------------ 10 2.067094ms 100 8.841597ms 1000 106.491732ms 10000 998.225023ms 100000 8.98172825s 1000000 1m 29.63203158s SELECT ------------------------------------------------ num of rows time taken ------------------------------------------------ 1000000 5.251337439s FIND & DISPLAY (with index declared) ------------------------------------------------ num of rows time taken ------------------------------------------------ 1000000 21.540603252s UPDATE ------------------------------------------------ num of rows time taken ------------------------------------------------ 1 1.330954ms ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ________________________________________________ PHP5 with MySQL (engine = MyISAM) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ INSERT ------------------------------------------------ num of rows time taken ------------------------------------------------ 10 0.0040680000000001s 100 0.011595s 1000 0.049718s 10000 0.457164s 100000 4s 1000000 42s SELECT ------------------------------------------------ num of rows time taken ------------------------------------------------ 1000000 <1s SELECT & DISPLAY ------------------------------------------------ num of rows time taken ------------------------------------------------ 1000000 20s ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ________________________________________________ PHP5 with MongoDB ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ INSERT ------------------------------------------------ num of rows time taken ------------------------------------------------ 10 0.065744s 100 0.190966s 1000 0.2163s 10000 1s 100000 8s 1000000 78s FIND ------------------------------------------------ num of rows time taken ------------------------------------------------ 1000000 <1s FIND & DISPLAY ------------------------------------------------ num of rows time taken ------------------------------------------------ 1000000 7s UPDATE ------------------------------------------------ num of rows time taken ------------------------------------------------ 1000000 9s ^ source: https://stackoverflow.com/questions/9702643/mysql-vs-mongodb-1000-reads MySQL is a very good engine, as other GPL-based engines are. MongoDB is a NoSQL engine written especially for Node.JS. Also, for a Metin2 server, a different database engine would provide little to none additional performance. Kind regards, Michael! -
need a one developer for website Metin2
MichaelM replied to Phanes's topic in Paid Support / Searching / Recruiting
-
The swimming system is insane! Would be nice to see this on private servers! Good job!
-
Question about code quest
MichaelM replied to xxx30xxx's topic in Community Support - Questions & Answers
Try set gold_expire = NOW() + INTERVAL x DAY instead of: gold_expire=DATE() + "..(get_time() + x*60*60*24).." -
Web script probblem ! :)
MichaelM replied to emanuel's topic in Community Support - Questions & Answers
$ip="SERVER IP"; Replace SERVER IP with your game server's ip address. If your website is hosted on the same machine as the gameserver then you're ip should be 127.0.0.1 (localhost). -
Searching trusted homepage scripter
MichaelM replied to FreZzwe's topic in Paid Support / Searching / Recruiting
Hi, @FreZzwe! Please contact me if you're still looking for help. -
Way to go!
-
FreeBSD 10.3 Networking Configuration
MichaelM replied to Summex's topic in Community Support - Questions & Answers
Activate ipv4 & dhcp. Set networking adapter as NAT. Run this: * Note, your network interface might not be em0, you have to change em0 with your interface. Kind regards. -
Insane!