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

Quote:

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

Quote:

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

Quote:

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

Quote:

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.

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

Quote:

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

Quote:

Originally Posted by Infictus .

Quote:

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

Quote:

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

Quote:

Project Manifesto can hold ALOT of players..

Quote:

Originally Posted by { Angelius } Originally Posted by DreadNought and where can i find it please ?