software/RELEASES/ircservices/achurch.org/services/lists/ircservices/2000/000882.html

   1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
   2 <HTML>
   3  <HEAD>
   4    <TITLE> [IRCServices] cheers. ideas.
   5    </TITLE>
   6    <LINK REL="Index" HREF="index.html" >
   7    <LINK REL="made" HREF="mailto:ircservices%40ircservices.za.net?Subject=%5BIRCServices%5D%20cheers.%20ideas.&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="000881.html">
  11    <LINK REL="Next"  HREF="000872.html">
  12  </HEAD>
  13  <BODY BGCOLOR="#ffffff">
  14    <H1>[IRCServices] cheers. ideas.</H1>
  15     <B>Chris Knipe</B>
  16     <A HREF="mailto:ircservices%40ircservices.za.net?Subject=%5BIRCServices%5D%20cheers.%20ideas.&In-Reply-To="
  17        TITLE="[IRCServices] cheers. ideas.">cgknipe at mweb.co.za
  18        </A><BR>
  19     <I>Sun Oct 15 10:28:56 PDT 2000</I>
  20     <P><UL>
  21         <LI>Previous message: <A HREF="000881.html">[IRCServices] cheers. ideas.
  22 </A></li>
  23         <LI>Next message: <A HREF="000872.html">[IRCServices] Ircd's and Services....
  24 </A></li>
  25          <LI> <B>Messages sorted by:</B>
  26               <a href="date.html#882">[ date ]</a>
  27               <a href="thread.html#882">[ thread ]</a>
  28               <a href="subject.html#882">[ subject ]</a>
  29               <a href="author.html#882">[ author ]</a>
  30          </LI>
  31        </UL>
  32     <HR>
  33 <!--beginarticle-->
  34 <PRE>----- Original Message -----
  35 From: Andrew Kempe &lt;<A HREF="http://www.ircservices.za.net/mailman/listinfo/ircservices">andrewk at icon.co.za</A>&gt;
  36 To: &lt;<A HREF="http://www.ircservices.za.net/mailman/listinfo/ircservices">ircservices at Snow.shadowfire.org</A>&gt;
  37 Sent: Sunday, October 15, 2000 7:15 PM
  38 Subject: RE: [IRCServices] cheers. ideas.
  39
  40
  41
  42 &gt;<i> I was referring to the question/suggestion of allowing other applications
  43 </I>to
  44 &gt;<i> update the database themselves. Those changes would be lost.
  45 </I>
  46 No they would not.  Example.  One record, with fields, nickname, setbit1,
  47 setbit2, and email
  48
  49 Application 1 and 2 retrieves the entire recordset, taking out all the
  50 fields.
  51
  52 Application 1: updates setbit1 to FALSE, setbit2 to TRUE and change email to
  53 <A HREF="http://www.ircservices.za.net/mailman/listinfo/ircservices">blah at blah</A>
  54 Application 2: updates setbit1 to TRUE
  55
  56 Both application will reflect the change.  In this case, the only issue is
  57 from whether or not the setbit1 is giong to conflict because it is updated
  58 by both applications.
  59
  60 I think what you are getting at because &quot;services will loose information&quot; is
  61 because the entire recordset for every nickname is updated.  This is why
  62 services is loosing performance (in my books).  Instead of just updating one
  63 field in the recordset, the entire recordset is saved again.  Because the
  64 entire recordset is saved again, yes THEN will data be lost if used by more
  65 than one application.  Update only the changed fields in the recordset, and
  66 everything will be just fine...
  67
  68 &gt;<i> I'm talking from indirect experience with other systems that use this
  69 </I>&gt;<i> approach. If you're so sure of the benefits, please feel free to implement
  70 </I>&gt;<i> them. I'm just stating what I think with regard to the time and resources
  71 </I>at
  72 &gt;<i> my disposal.
  73 </I>
  74 Very well, and understandable. I will be starting SQL based tests.  I've
  75 noticed allready yesterday night, by just added random data to SQL tables,
  76 that SQL starts to slow down at about 3,500 records per table.  But please,
  77 if we are up to this, lets test this, and see what and where we need to move
  78 to?
  79
  80
  81 ---
  82 Regards,
  83 Chris Knipe
  84 Cell: (083) 430-8151
  85
  86
  87
  88
  89 ---------------------------------------------------------------
  90 To unsubscribe, send email to <A HREF="http://www.ircservices.za.net/mailman/listinfo/ircservices">majordomo at ender.shadowfire.org</A>
  91 with &quot;unsubscribe ircservices&quot; in the body, without the quotes.
  92
  93
  94 </PRE>
  95
  96 <!--endarticle-->
  97     <HR>
  98     <P><UL>
  99         <!--threads-->
 100         <LI>Previous message: <A HREF="000881.html">[IRCServices] cheers. ideas.
 101 </A></li>
 102         <LI>Next message: <A HREF="000872.html">[IRCServices] Ircd's and Services....
 103 </A></li>
 104          <LI> <B>Messages sorted by:</B>
 105               <a href="date.html#882">[ date ]</a>
 106               <a href="thread.html#882">[ thread ]</a>
 107               <a href="subject.html#882">[ subject ]</a>
 108               <a href="author.html#882">[ author ]</a>
 109          </LI>
 110        </UL>
 111
 112 </body></html>