|
You last visited: Today at 09:20
Advertisement
Help with database types
Discussion on Help with database types within the CO2 Private Server forum part of the Conquer Online 2 category.
|
View Poll Results: Which is better in your opinion
|
|
NotePad
|
   
|
2 |
18.18% |
|
MySQL
|
  
|
9 |
81.82% |
02/05/2013, 04:13
|
#1
|
elite*gold: 0 
Join Date: Aug 2011
Posts: 31
Received Thanks: 1
|
Help with database types
Hello Guys i just needed to know which is the best database to use in conquer, shall i use .text files or mysql and why.
thanks for helping 
|
|
|
|
02/05/2013, 04:57
|
#2
|
elite*gold: 0
Join Date: Sep 2012
Posts: 775
Received Thanks: 327
|
database ofc , why ? google , i swear google works in egypt
and using database is way easier and better than using texts
|
|
|
|
|
02/05/2013, 07:37
|
#3
|
elite*gold: 12
Join Date: Jul 2011
Posts: 8,211
Received Thanks: 4,114
|
Last time I checked, notepad wasn't a database type. I think you mean "flat-file database", in which case I would strongly advice against that. It doesn't scale well for servers.
|
|
|
|
|
02/05/2013, 13:17
|
#4
|
elite*gold: 0
Join Date: Aug 2011
Posts: 31
Received Thanks: 1
|
i can do well in the notepad i can use datagrid view for that but whats faster in loading and makes the server lighter and faster ?
|
|
|
|
|
02/05/2013, 13:19
|
#5
|
elite*gold: 0
Join Date: Apr 2007
Posts: 26
Received Thanks: 2
|
oracle 
well mysql is your right decision. ability to cache, own procs, methods, views foreign keys and so on.
|
|
|
|
|
02/05/2013, 13:43
|
#6
|
elite*gold: 0
Join Date: Aug 2011
Posts: 31
Received Thanks: 1
|
but i think it makes the server heavier and it loads so slow if many records is that right ?
|
|
|
|
|
02/05/2013, 14:36
|
#7
|
elite*gold: 0
Join Date: May 2005
Posts: 1,892
Received Thanks: 918
|
No, MySQL is optimized in ways that it would be redundant to wrap up the same functionality with a flat-file database, as MySQL manages a flat-file database in their own format under the hood. Also, MySQL is heavily optimized for reads since the caller has to wait for retrieval of the data.
|
|
|
|
|
02/05/2013, 15:38
|
#8
|
elite*gold: 0
Join Date: Dec 2012
Posts: 1,761
Received Thanks: 946
|
Mssql anyone?
|
|
|
|
|
02/05/2013, 18:01
|
#9
|
elite*gold: 21
Join Date: Jul 2005
Posts: 9,193
Received Thanks: 5,376
|
Quote:
Originally Posted by Super Aids
Mssql anyone?
|
BerkleyDB anyone?
Not really worth it for a game as small as conquer with so many static things but still a rather interesting system.
SWGEmu is using it for all of their volatile data (due to the insane update speed it offers) combined with I believe MYSQL for their accounts and other more permanent data.
|
|
|
|
|
02/05/2013, 18:17
|
#10
|
elite*gold: 0
Join Date: Dec 2012
Posts: 1,761
Received Thanks: 946
|
Well .NET already has Mssql covered in the framework + Visual Studio with datasets = godlike to use as database management.
|
|
|
|
|
02/05/2013, 18:19
|
#11
|
elite*gold: 20
Join Date: Mar 2006
Posts: 6,125
Received Thanks: 2,518
|
I prefer WordPad myself...
|
|
|
|
|
02/05/2013, 21:18
|
#12
|
elite*gold: 0
Join Date: Sep 2012
Posts: 775
Received Thanks: 327
|
Quote:
Originally Posted by Korvacs
I prefer WordPad myself...
|
|
|
|
|
|
02/05/2013, 22:29
|
#13
|
elite*gold: 0
Join Date: Aug 2011
Posts: 31
Received Thanks: 1
|
BerkleyDB i will check that thanks
|
|
|
|
|
02/05/2013, 23:41
|
#14
|
elite*gold: 21
Join Date: Jul 2005
Posts: 9,193
Received Thanks: 5,376
|
Quote:
Originally Posted by hazemz
BerkleyDB i will check that thanks |
Was kinda joking... for a program as small as conquer you're best going with mssql/mysql depending on your needs and what you prefer.
The fact of the matter is that if flatfile (including text, xml and ini files) were in any way better for servers then databases would have never been invented.
They are perfectly fine for storing settings and configurations, that's what they are good for. Databases scale better as you add more users and are simply better for any sort of server app where data is being inserted, retrieved or modified regularly.
|
|
|
|
 |
Similar Threads
|
[Official Release] Rainbow Database: Vampire/Godship/Legionairre Database!
04/25/2021 - EO PServer Guides & Releases - 106 Replies
http://i43.tinypic.com/jgo485.png
Additional: The database contains all material and server features which I alone coded, designed and created. I can barely recall if their were any bugs. I think there was with one of the vampire skills. People said it was supposed to be an xp skill but they could use it without having to be on XP. So its pretty minor but if you find any other problems please report them to this thread and i'll make a fix asap.
Many database releases have come before this...
|
map types
06/30/2009 - CO2 Programming - 0 Replies
I dont know anything about the map types. If I wanted to make a map where you can pk, respawn in another map when you die, and no magic attack is allowed, anyone know what number I would need for the type? If you wanna throw some other ones in I didnt ask for, for future reference I don't think I'd mind :)
|
ARCHLORD Monster Database - Drop Rates - Types - etc !! :D
06/09/2009 - Archlord - 53 Replies
Ok, I assume Drop Mediation = Drop %, Other than that the rest is easy to understand :) enjoy & YW :D
The List has all in game Monsters Except those with a Standard drop % of 1 (Excluded, because these are all normal/lowest drop %).
If name is not in this list, it's Drop %(Mediation) = 1 (lowest). There are drop % 1.2, 1.4, 1.6, 1.68, 1.96, 2.24, 30, 40, 50
Remember to look at rank of items too, this is what seperates good from better :) If that...
|
All times are GMT +2. The time now is 09:20.
|
|
