"4" Questions please give it some of your time :)

[{ Angelius }]

Search Forums dident help me alot :P

its "4" Questions

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

[DePredaTe]

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.

[Syst3m_W1z4rd]

Originally Posted by { Angelius }

Search Forums dident help me alot :P

its "4" Questions

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

View the quote.

[{ Angelius }]

@DePredaTe

4. I'm not sure, i dont think theres just a certain source. you would definitely have to do some extra coding

for sure and its not gonna be a problem but at least i need something to start with
thank you

@Syst3m_W1z4rd

Internet Speed.^
MySQL Connection.^
Codes u have in ur source.X
If ur under DOS/DDOS Attack.^
If ur pc is **** or filled up with ****.^

it is the codes i have in my source
thank you so much

[KraHen]

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.

[Syst3m_W1z4rd]

Originally Posted by KraHen

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 ><

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

[Nullable]

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).

[Infictus]

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

.

[Syst3m_W1z4rd]

Originally Posted by Infictus

.

HE SHOULD NOT LEAVE HIS DATABASE FLATFILE IMO!!!!!
Unleast he know what his doing...

[{ Angelius }]

Originally Posted by Syst3m_W1z4rd

HE SHOULD NOT LEAVE HIS DATABASE FLATFILE IMO!!!!!
Unleast he know what his doing...

im not gonna leave it like what it is its gonna be changed no more flatfiles but still the problem is I NEED A BASE to start with :xD
thank you

[Syst3m_W1z4rd]

Hybrids sources, Impulse source would be my suggestion

[Infictus]

Originally Posted by { Angelius }

Originally Posted by Syst3m_W1z4rd

im not gonna leave it like what it is its gonna be changed no more flatfiles but still the problem is I NEED A BASE to start with :xD
thank you

For base i suggest hybrid 5017 bugless basic source, or arco's 5071

[_DreadNought_]

Project Manifesto can hold ALOT of players..

[{ Angelius }]

Originally Posted by DreadNought

Project Manifesto can hold ALOT of players..

and where can i find it please ?

[.Sticky]

Originally Posted by { Angelius }

Originally Posted by DreadNought

and where can i find it please ?

Hybrid.