============================================
To: <[email protected]>
From: "Despret, Jerome" <[EMAIL PROTECTED]>
Subject: RE: MYSQL
>I'm more concern about the lack of transactional consistency in MySQL :)
Actually, the latest version of MySQL does have transactions.. Just not
subselects, or stored proceedures. Both of these features are available in the
more robustly featured PostgreSQL server..
As to comments made about the lack of significant performance increase when
using a database over a plain text file.. Sure, they probably work just as fast
for loading/saving of data, but it is much easier and faster to do reporting on
various statistics of your game world with SQL...
#A quick select to determine how quickly/easily each class can level.
select SUM(pc.hours_played) / SUM(ch.level) as hours_per_lvl, ch.class
from pc_data pc, character_data ch where pc.character_id = ch.id
group by class;
#A quick report on the damage for all weapons grouped by type.
select MIN(av_damage) as min,
SUM(av_damage) / SUM(id) as average,
MAX(av_damage) as max
from weapon_data where level = 35
group by weapon_type;
This is where the strength of the database lies.. Quick, easy and flexible
reporting tools.
~Kender
=====
-----BEGIN GEEK CODE BLOCK-----
Version 3.1
GCS/L/C/O d-(+) s++:+ a-- C+++$>++++ UBLS++++$
P+++(--)$ L++>+++ E--- W+>++$ N !o K? w(--) !O
M- !V PS+ PE(++) Y+ PGP->+ t- 5 X+() R(+) tv+@
b++(+++) !DI+++ D G(-) e>+++$ h---() r+++ y+++
------END GEEK CODE BLOCK------
__________________________________________________
Do You Yahoo!?
Yahoo! Greetings - send holiday greetings for Easter, Passover
http://greetings.yahoo.com/
