[IRCServices] cheers. ideas.

Chris Knipe cgknipe at mweb.co.za
Sun Oct 15 10:28:56 PDT 2000


----- Original Message -----
From: Andrew Kempe <andrewk at icon.co.za>
To: <ircservices at Snow.shadowfire.org>
Sent: Sunday, October 15, 2000 7:15 PM
Subject: RE: [IRCServices] cheers. ideas.



> I was referring to the question/suggestion of allowing other applications
to
> update the database themselves. Those changes would be lost.

No they would not.  Example.  One record, with fields, nickname, setbit1,
setbit2, and email

Application 1 and 2 retrieves the entire recordset, taking out all the
fields.

Application 1: updates setbit1 to FALSE, setbit2 to TRUE and change email to
blah at blah
Application 2: updates setbit1 to TRUE

Both application will reflect the change.  In this case, the only issue is
from whether or not the setbit1 is giong to conflict because it is updated
by both applications.

I think what you are getting at because "services will loose information" is
because the entire recordset for every nickname is updated.  This is why
services is loosing performance (in my books).  Instead of just updating one
field in the recordset, the entire recordset is saved again.  Because the
entire recordset is saved again, yes THEN will data be lost if used by more
than one application.  Update only the changed fields in the recordset, and
everything will be just fine...

> I'm talking from indirect experience with other systems that use this
> approach. If you're so sure of the benefits, please feel free to implement
> them. I'm just stating what I think with regard to the time and resources
at
> my disposal.

Very well, and understandable. I will be starting SQL based tests.  I've
noticed allready yesterday night, by just added random data to SQL tables,
that SQL starts to slow down at about 3,500 records per table.  But please,
if we are up to this, lets test this, and see what and where we need to move
to?


---
Regards,
Chris Knipe
Cell: (083) 430-8151




---------------------------------------------------------------
To unsubscribe, send email to majordomo at ender.shadowfire.org
with "unsubscribe ircservices" in the body, without the quotes.