1 <!DOCTYPE HTML PUBLIC
"-//W3C//DTD HTML 3.2//EN">
4 <TITLE> [IRCServices Coding] New IRC Services project
6 <LINK REL=
"Index" HREF=
"index.html" >
7 <LINK REL=
"made" HREF=
"mailto:ircservices-coding%40ircservices.za.net?Subject=%5BIRCServices%20Coding%5D%20New%20IRC%20Services%20project&In-Reply-To=">
8 <META NAME=
"robots" CONTENT=
"index,nofollow">
9 <META http-equiv=
"Content-Type" content=
"text/html; charset=us-ascii">
10 <LINK REL=
"Previous" HREF=
"001796.html">
11 <LINK REL=
"Next" HREF=
"001797.html">
13 <BODY BGCOLOR=
"#ffffff">
14 <H1>[IRCServices Coding] New IRC Services project
</H1>
16 <A HREF=
"mailto:ircservices-coding%40ircservices.za.net?Subject=%5BIRCServices%20Coding%5D%20New%20IRC%20Services%20project&In-Reply-To="
17 TITLE=
"[IRCServices Coding] New IRC Services project">brain at brainbox.winbot.co.uk
19 <I>Thu Dec
19 10:
46:
07 PST
2002</I>
21 <LI>Previous message:
<A HREF=
"001796.html">[IRCServices Coding] New IRC Services project
23 <LI>Next message:
<A HREF=
"001797.html">[IRCServices Coding] New IRC Services project
25 <LI> <B>Messages sorted by:
</B>
26 <a href=
"date.html#1793">[ date ]
</a>
27 <a href=
"thread.html#1793">[ thread ]
</a>
28 <a href=
"subject.html#1793">[ subject ]
</a>
29 <a href=
"author.html#1793">[ author ]
</a>
34 <PRE>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.
36 BotServs however i do agree with (i digress here) as i am a big fan of developing and using bots of all kinds ;)
38 ><i>-----BEGIN PGP SIGNED MESSAGE-----
41 </I>><i>On Thursday
19 December
2002 19:
21, Craig Edwards wrote:
42 </I>>><i> MySQL databases arent really a good idea for an ircservices server on a
43 </I>>><i> large network - imagine the number of constant queries involved, it would
44 </I>>><i> be a much busier situation than many large websites, you would have to make
45 </I>>><i> a query for practically every RAW irc line from your uplink, e.g. for
46 </I>>><i> checking access, etc. If not for every RAW line, but for every MODE, JOIN,
47 </I>>><i> and PRIVMSG to a pseudoclient, and every connect, NICK, etc... Not to
48 </I>>><i> mention that MySQL's transaction support isnt that good (MySQL's one and
49 </I>>><i> only downfall) which would mean maybe a database such as PostgreSQL may
50 </I>>><i> work much better in this case. I have my doubts about performance though.
51 </I>>><i> Would connections to the database be persistent? Im not sure about the low
52 </I>>><i> level workings of DBMS systems but for this kind of application the
53 </I>>><i> connection would not need to be closed after each query, the slowdowns
54 </I>>><i> would be unbelievably slow.
56 </I>><i>If i dont recall to incorrectly, DALnet's services are MySQL based.
58 </I>><i>Yours Sincerely
60 </I>><i>Thomas Juberg Stens
ås
62 </I>><i>- -- What we do in life echoes in eternity
64 </I>><i>-----BEGIN PGP SIGNATURE-----
65 </I>><i>Version: GnuPG v1.2
.1 (GNU/Linux)
67 </I>><i>iD8DBQE+AhRdm5JSuDogRncRAmC9AKDHhGQhXQJt1qAzUYP9GvDt1TpPsQCfWJVL
68 </I>><i>yEBcQi3kIq6+rfxDWl09w/c=
70 </I>><i>-----END PGP SIGNATURE-----
72 </I>><i>------------------------------------------------------------------
73 </I>><i>To unsubscribe or change your subscription options, visit:
74 </I>><i><A HREF=
"http://www.ircservices.za.net/mailman/listinfo/ircservices-coding">http://www.ircservices.za.net/mailman/listinfo/ircservices-coding
</A>
84 <LI>Previous message:
<A HREF=
"001796.html">[IRCServices Coding] New IRC Services project
86 <LI>Next message:
<A HREF=
"001797.html">[IRCServices Coding] New IRC Services project
88 <LI> <B>Messages sorted by:
</B>
89 <a href=
"date.html#1793">[ date ]
</a>
90 <a href=
"thread.html#1793">[ thread ]
</a>
91 <a href=
"subject.html#1793">[ subject ]
</a>
92 <a href=
"author.html#1793">[ author ]
</a>