[IRCServices Coding] New IRC Services project

Craig Edwards brain at brainbox.winbot.co.uk
Thu Dec 19 10:46:07 PST 2002


Dalnets services are frequently split from their uplink, due to the fact that they cant handle the load placed upon them :) A flat file db would operate much faster with reasonable hardware, no extra socket connections have to be established to make queries.

BotServs however i do agree with (i digress here) as i am a big fan of developing and using bots of all kinds ;)

>-----BEGIN PGP SIGNED MESSAGE-----
>Hash: SHA1
>
>On Thursday 19 December 2002 19:21, Craig Edwards wrote:
>> MySQL databases arent really a good idea for an ircservices server on a
>> large network - imagine the number of constant queries involved, it would
>> be a much busier situation than many large websites, you would have to make
>> a query for practically every RAW irc line from your uplink, e.g. for
>> checking access, etc. If not for every RAW line, but for every MODE, JOIN,
>> and PRIVMSG to a pseudoclient, and every connect, NICK, etc... Not to
>> mention that MySQL's transaction support isnt that good (MySQL's one and
>> only downfall) which would mean maybe a database such as PostgreSQL may
>> work much better in this case. I have my doubts about performance though.
>> Would connections to the database be persistent? Im not sure about the low
>> level workings of DBMS systems but for this kind of application the
>> connection would not need to be closed after each query, the slowdowns
>> would be unbelievably slow.
>
>If i dont recall to incorrectly, DALnet's services are MySQL based.
>- -- 
>Yours Sincerely
>
>Thomas Juberg Stensås
>
>- -- What we do in life echoes in eternity
>
>-----BEGIN PGP SIGNATURE-----
>Version: GnuPG v1.2.1 (GNU/Linux)
>
>iD8DBQE+AhRdm5JSuDogRncRAmC9AKDHhGQhXQJt1qAzUYP9GvDt1TpPsQCfWJVL
>yEBcQi3kIq6+rfxDWl09w/c=
>=ZwSu
>-----END PGP SIGNATURE-----
>
>------------------------------------------------------------------
>To unsubscribe or change your subscription options, visit:
>http://www.ircservices.za.net/mailman/listinfo/ircservices-coding