1: what can cuz the lag/crash/disconnecting players/reject players connection/slow server .
2: what is better! to leave the loading/saving for all the Features on flatfiles like .txt files or redo it and start using the the sql connections to save/load from the data base .
3: what can make the server slower! Mysql database connections or the flat files >>>.txt files saving/loading
4: Where can i find a good base that can hold like a 500/700 player yeah that much and thats my goal if im gonna start a server
im still learning here so to start coding/creating everything even if i had to start from nothing, Zero, scratch is a good idea But... i cant make it happen so at least i need the answers for those Questions and that base/source that im asking for and than i can start or better say then i have something to start with
you spent that 3 min of your time to read my post so please if you have the answer for any of those Questions spend another 5 min to post the answer back
thanks every one
Angelius,
1. anything can cause the players to disconnect. A bad host, would be my best guess if there are no errors.
2. Mysql
3.IMO, i think mysql is faster, but idk how to switch it from flatfile to mysql.
4. I'm not sure, i dont think theres just a certain source. you would definitely have to do some extra coding.
1: what can cuz the lag/crash/disconnecting players/reject players connection/slow server .
Internet Speed.
MySQL Connection.
Codes u have in ur source.
If ur under DOS/DDOS Attack.
If ur pc is crap or filled up with crap.
2: what is better! to leave the loading/saving for all the Features on flatfiles like .txt files or redo it and start using the the sql connections to save/load from the data base .
Do plain SQL. I would suggest MSSQL, because is better then MySQL.
Infact flatfiles are not good for databases, they are for intializing (How do I spell it?) configurations like ip, paths, items etc.
Characters, Mobs and things u need to update all the time, should be stored in the SQL.
3: what can make the server slower! Mysql database connections or the flat files >>>.txt files saving/loading
Flatfile of couse, because they read the whole stream to find what they need.
SQL Will take X/Y and find direct what it needs, without going through all things wich is not needed.
4: Where can i find a good base that can hold like a 500/700 player yeah that much and thats my goal if im gonna start a server
No where, serious there is no public sources that can do that.
I think u will need to be pretty damn crazy with sockets, if ur gonna do that.
If this is ur goal, then u got a long way dude.
im still learning here so to start coding/creating everything even if i had to start from nothing, Zero, scratch is a good idea But... i cant make it happen so at least i need the answers for those Questions and that base/source that im asking for and than i can start or better say then i have something to start with
you spent that 3 min of your time to read my post so please if you have the answer for any of those Questions spend another 5 min to post the answer back
thanks every one
1. MSSQL is not necessarily better than MySQL.
2. There are released sources which can hold many players, just look around and you will find stable sources.
1. MSSQL is not necessarily better than MySQL.
2. There are released sources which can hold many players, just look around and you will find stable sources.
I know this is old, but couldn't find a better >< I will tell if I find ><
Code:
Feature SQL Server 2000 MySQL v5.0 (MyISAM)
Column name length 128 64
Index name length 128 64
Table name length 128 64
Max indexes per table 250 64 (128 with recompile)
Index length 900 1024
Max index column length 900 255
Columns per index 16 16
Max char size 8000 255
Max varchar size 8000 65532
Max blob size 2147483647 2147483647
Max columns in GROUP BY Limited by number of bytes (8060) 64
Max columns in ORDER BY Limited by number of bytes (8060) 64
Tables per SELECT statement 256 31
Max columns per table 1024 3398
Max table row length 8036 65534
Longest SQL statement 16777216 1048574
Constant string size in SELECT 16777207 1048565
For some reason everyone who posted about connections just referred to the server specs/uplink, nobody even seemed to bother about clients.
If you have a client with a slow connection, it WILL slow your server up because of blocking send() calls due to filled up tcp buffers.
Polling the socket for write availability and writing data ONLY if the socket is available for writing makes sure that you won't have such problems.
I've also yet to see a single public server, except bone-you's XSCO, that polls sockets for writing availability (I haven't checked all of them, so I might be wrong by generalizing that).
1: what can cuz the lag/crash/disconnecting players/reject players connection/slow server . - Everything, propably bad host or some bad server files
2: what is better! to leave the loading/saving for all the Features on flatfiles like .txt files or redo it and start using the the sql connections to save/load from the data base . - flatfile imo
3: what can make the server slower! Mysql database connections or the flat files >>>.txt files saving/loading - i heared that the flatfile is fastest database loading system
4: Where can i find a good base that can hold like a 500/700 player yeah that much and thats my goal if im gonna start a server - not sure about that
