Antville Project

Problem with scheduler

Looks like we have a problem with the scheduler on antville.org. A grep from the access log:

[2003/02/06 13:48] antville:internal:scheduler 333 marked, 0 inserted, 333 updated, 0 deleted in 898358 millis [2003/02/06 13:56] antville:internal:scheduler 248 marked, 0 inserted, 248 updated, 0 deleted in 455056 millis [2003/02/06 14:04] antville:internal:scheduler 93 marked, 0 inserted, 93 updated, 0 deleted in 473335 millis

Possible problems are DB write performance or concurrent write locks. I'm investigating...

comment    

 
hns, February 6, 2003 at 2:53:25 PM CET

Re: Problem with scheduler

OK, as far as I can see, one probelmatic section is this in global writeReadLog():

      var site = root.get(el.site);
      if (!site)
         continue;
      var story = site.allstories.get(String(el.story));
      if (!story)
         continue;
      story.reads = el.reads;

What happens here is that for each story being updated, the site and its full story index needs to be loaded. I have checked in a mod to root/type.properties that allows stories to be loaded via root/storiesByID without the whole story index being loaded (yes, specifying an accessname does have that effect - I know that's an insider trick ;-).

I'll change writeReadLog() to use that to access the stories:

      var story = root.storiesByID.get(String(el.story));
      if (!story)
         continue;
      story.reads = el.reads;

Is that OK with everybody?

link  


... comment


The Antville Server Fund has been a great success. Thanks to everybody who contributed!
online for 8549 Days
last updated: 1/4/11, 10:22 AM
status
Youre not logged in ... Login
menu
November 2024
SunMonTueWedThuFriSat
12
3456789
10111213141516
17181920212223
24252627282930
July
recent
zfuture's house here is zfuture's
house
by zfuture (7/31/03, 2:59 AM)
i understand your concerns however,
i hardly can think of a solution. certainly, if the...
by tobi (7/29/03, 9:47 AM)
Found several more similar sites
listed This is getting to be quite a concern to...
by cobalt123 (7/27/03, 7:56 PM)
Second Post Alert on Referrer
bug livecatz I put this into "help" and now here:...
by cobalt123 (7/26/03, 7:14 PM)
well it's not easy to
find from here, anyway. think we should include a link,...
by tobi (7/24/03, 11:25 AM)
So finally I found
the helma Bugzilla - stupid me.
by mdornseif (7/24/03, 10:28 AM)
clock not that it's particularly
earthshattering but the antclock is running slow by about 15...
by kohlehydrat (7/23/03, 8:25 PM)
but blogosphere.us isn't can't really
be rated as spam can it?
by kohlehydrat (7/23/03, 8:08 PM)
More referrer spam www.webfrost.com
by Irene (7/23/03, 7:55 PM)
How to log skin names
I accessed to console?? Hi, I would like to know...
by winson (7/23/03, 4:12 PM)

Click here to get an XML version of this weblog.

Made with Antville
powered by
Helma Object Publisher