software/!RELEASES/ircservices/achurch.org/services/lists/ircservices-coding/2002/001793.html

   1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
   2 <HTML>
   3  <HEAD>
   4    <TITLE> [IRCServices Coding] New IRC Services project
   5    </TITLE>
   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">
  12  </HEAD>
  13  <BODY BGCOLOR="#ffffff">
  14    <H1>[IRCServices Coding] New IRC Services project</H1>
  15     <B>Craig Edwards</B>
  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
  18        </A><BR>
  19     <I>Thu Dec 19 10:46:07 PST 2002</I>
  20     <P><UL>
  21         <LI>Previous message: <A HREF="001796.html">[IRCServices Coding] New IRC Services project
  22 </A></li>
  23         <LI>Next message: <A HREF="001797.html">[IRCServices Coding] New IRC Services project
  24 </A></li>
  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>
  30          </LI>
  31        </UL>
  32     <HR>
  33 <!--beginarticle-->
  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.
  35
  36 BotServs however i do agree with (i digress here) as i am a big fan of developing and using bots of all kinds ;)
  37
  38 &gt;<i>-----BEGIN PGP SIGNED MESSAGE-----
  39 </I>&gt;<i>Hash: SHA1
  40 </I>&gt;<i>
  41 </I>&gt;<i>On Thursday 19 December 2002 19:21, Craig Edwards wrote:
  42 </I>&gt;&gt;<i> MySQL databases arent really a good idea for an ircservices server on a
  43 </I>&gt;&gt;<i> large network - imagine the number of constant queries involved, it would
  44 </I>&gt;&gt;<i> be a much busier situation than many large websites, you would have to make
  45 </I>&gt;&gt;<i> a query for practically every RAW irc line from your uplink, e.g. for
  46 </I>&gt;&gt;<i> checking access, etc. If not for every RAW line, but for every MODE, JOIN,
  47 </I>&gt;&gt;<i> and PRIVMSG to a pseudoclient, and every connect, NICK, etc... Not to
  48 </I>&gt;&gt;<i> mention that MySQL's transaction support isnt that good (MySQL's one and
  49 </I>&gt;&gt;<i> only downfall) which would mean maybe a database such as PostgreSQL may
  50 </I>&gt;&gt;<i> work much better in this case. I have my doubts about performance though.
  51 </I>&gt;&gt;<i> Would connections to the database be persistent? Im not sure about the low
  52 </I>&gt;&gt;<i> level workings of DBMS systems but for this kind of application the
  53 </I>&gt;&gt;<i> connection would not need to be closed after each query, the slowdowns
  54 </I>&gt;&gt;<i> would be unbelievably slow.
  55 </I>&gt;<i>
  56 </I>&gt;<i>If i dont recall to incorrectly, DALnet's services are MySQL based.
  57 </I>&gt;<i>- --
  58 </I>&gt;<i>Yours Sincerely
  59 </I>&gt;<i>
  60 </I>&gt;<i>Thomas Juberg Stens&#229;s
  61 </I>&gt;<i>
  62 </I>&gt;<i>- -- What we do in life echoes in eternity
  63 </I>&gt;<i>
  64 </I>&gt;<i>-----BEGIN PGP SIGNATURE-----
  65 </I>&gt;<i>Version: GnuPG v1.2.1 (GNU/Linux)
  66 </I>&gt;<i>
  67 </I>&gt;<i>iD8DBQE+AhRdm5JSuDogRncRAmC9AKDHhGQhXQJt1qAzUYP9GvDt1TpPsQCfWJVL
  68 </I>&gt;<i>yEBcQi3kIq6+rfxDWl09w/c=
  69 </I>&gt;<i>=ZwSu
  70 </I>&gt;<i>-----END PGP SIGNATURE-----
  71 </I>&gt;<i>
  72 </I>&gt;<i>------------------------------------------------------------------
  73 </I>&gt;<i>To unsubscribe or change your subscription options, visit:
  74 </I>&gt;<i><A HREF="http://www.ircservices.za.net/mailman/listinfo/ircservices-coding">http://www.ircservices.za.net/mailman/listinfo/ircservices-coding</A>
  75 </I>
  76
  77
  78 </PRE>
  79
  80 <!--endarticle-->
  81     <HR>
  82     <P><UL>
  83         <!--threads-->
  84         <LI>Previous message: <A HREF="001796.html">[IRCServices Coding] New IRC Services project
  85 </A></li>
  86         <LI>Next message: <A HREF="001797.html">[IRCServices Coding] New IRC Services project
  87 </A></li>
  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>
  93          </LI>
  94        </UL>
  95
  96 </body></html>