software/RELEASES/ircservices/achurch.org/services/lists/ircservices-coding/2002/001792.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=200212191833.gBJIX7C01586%40localhost.localdomain">
   8    <META NAME="robots" CONTENT="index,nofollow">
   9    <META http-equiv="Content-Type" content="text/html; charset=us-ascii">
  10    <LINK REL="Previous"  HREF="001791.html">
  11    <LINK REL="Next"  HREF="001794.html">
  12  </HEAD>
  13  <BODY BGCOLOR="#ffffff">
  14    <H1>[IRCServices Coding] New IRC Services project</H1>
  15     <B>Thomas J. Stens&#229;s</B>
  16     <A HREF="mailto:ircservices-coding%40ircservices.za.net?Subject=%5BIRCServices%20Coding%5D%20New%20IRC%20Services%20project&In-Reply-To=200212191833.gBJIX7C01586%40localhost.localdomain"
  17        TITLE="[IRCServices Coding] New IRC Services project">ShadowMaster at Shadow-Realm.org
  18        </A><BR>
  19     <I>Thu Dec 19 10:47:57 PST 2002</I>
  20     <P><UL>
  21         <LI>Previous message: <A HREF="001791.html">[IRCServices Coding] New IRC Services project
  22 </A></li>
  23         <LI>Next message: <A HREF="001794.html">[IRCServices Coding] New IRC Services project
  24 </A></li>
  25          <LI> <B>Messages sorted by:</B>
  26               <a href="date.html#1792">[ date ]</a>
  27               <a href="thread.html#1792">[ thread ]</a>
  28               <a href="subject.html#1792">[ subject ]</a>
  29               <a href="author.html#1792">[ author ]</a>
  30          </LI>
  31        </UL>
  32     <HR>
  33 <!--beginarticle-->
  34 <PRE>-----BEGIN PGP SIGNED MESSAGE-----
  35 Hash: SHA1
  36
  37 On Thursday 19 December 2002 19:21, Craig Edwards wrote:
  38 &gt;<i> MySQL databases arent really a good idea for an ircservices server on a
  39 </I>&gt;<i> large network - imagine the number of constant queries involved, it would
  40 </I>&gt;<i> be a much busier situation than many large websites, you would have to make
  41 </I>&gt;<i> a query for practically every RAW irc line from your uplink, e.g. for
  42 </I>&gt;<i> checking access, etc. If not for every RAW line, but for every MODE, JOIN,
  43 </I>&gt;<i> and PRIVMSG to a pseudoclient, and every connect, NICK, etc... Not to
  44 </I>&gt;<i> mention that MySQL's transaction support isnt that good (MySQL's one and
  45 </I>&gt;<i> only downfall) which would mean maybe a database such as PostgreSQL may
  46 </I>&gt;<i> work much better in this case. I have my doubts about performance though.
  47 </I>&gt;<i> Would connections to the database be persistent? Im not sure about the low
  48 </I>&gt;<i> level workings of DBMS systems but for this kind of application the
  49 </I>&gt;<i> connection would not need to be closed after each query, the slowdowns
  50 </I>&gt;<i> would be unbelievably slow.
  51 </I>
  52 If i dont recall to incorrectly, DALnet's services are MySQL based.
  53 - --
  54 Yours Sincerely
  55
  56 Thomas Juberg Stens&#229;s
  57
  58 - -- What we do in life echoes in eternity
  59
  60 -----BEGIN PGP SIGNATURE-----
  61 Version: GnuPG v1.2.1 (GNU/Linux)
  62
  63 iD8DBQE+AhRdm5JSuDogRncRAmC9AKDHhGQhXQJt1qAzUYP9GvDt1TpPsQCfWJVL
  64 yEBcQi3kIq6+rfxDWl09w/c=
  65 =ZwSu
  66 -----END PGP SIGNATURE-----
  67
  68
  69 </PRE>
  70
  71 <!--endarticle-->
  72     <HR>
  73     <P><UL>
  74         <!--threads-->
  75         <LI>Previous message: <A HREF="001791.html">[IRCServices Coding] New IRC Services project
  76 </A></li>
  77         <LI>Next message: <A HREF="001794.html">[IRCServices Coding] New IRC Services project
  78 </A></li>
  79          <LI> <B>Messages sorted by:</B>
  80               <a href="date.html#1792">[ date ]</a>
  81               <a href="thread.html#1792">[ thread ]</a>
  82               <a href="subject.html#1792">[ subject ]</a>
  83               <a href="author.html#1792">[ author ]</a>
  84          </LI>
  85        </UL>
  86
  87 </body></html>