IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Open Forum / Re: It is faster, but . .
Post #50,808
by jlalexander
Picture of jlalexander
9/6/02 9:44:08 AM
Reply
New Re: It is faster, but . .
Yeah, I'd chalk the majority of it up to Scott's SQL optimization, a minority of it to more RAM and multiple CPU's on this new server...

As for the latency, I think that's just an odditity with Postgres. Watching top on the box, periodically Postgres will spike the CPUs, lagging all the processes on the box, obviously.

I can only guess that that's another query we could optimize somewhere in the system. But, who knows. I'm not real keen with Postgres, myself.


-Jason
----

My pid is Inigo Montoya. You "killed -9" my parent process. Prepare to vi.
Post #50,976
by deSitter
Picture of deSitter
9/7/02 11:18:01 AM
Reply
New Re: It is faster, but . .
Can't you set a timer to make it refresh more often? I have no idea how this board works, but when I was thinking about making a forum, I had this idea of the post as an object and that the thing would almost be interrupt-driven, that is, didn't wait for user input directly but just assumed it would be coming. That way it could always be repsonsive to live posts, which is the thing that psychologically seems to show up as wait time, and you want to minimize that.

It does seem snappier - at times.
-drl
     Is it *JUST* me... - (folkert) - (16) - Sept. 5, 2002, 11:06:44 PM EDT
         It is faster, but . . - (Andrew Grygus) - (3) - Sept. 5, 2002, 11:17:58 PM EDT
             Ditto, here. -NT - (a6l6e6x) - Sept. 5, 2002, 11:30:49 PM EDT
             Re: It is faster, but . . - (jlalexander) - (1) - Sept. 6, 2002, 09:44:08 AM EDT
                 Re: It is faster, but . . - (deSitter) - Sept. 7, 2002, 11:18:01 AM EDT
         Not just you - (Yendor) - Sept. 6, 2002, 12:43:47 AM EDT
         Latency occasionally__quite__long, but mostly fast.. sofar -NT - (Ashton) - Sept. 6, 2002, 01:10:58 AM EDT
         Re: Is it *JUST* me... - (admin) - (7) - Sept. 6, 2002, 08:41:41 AM EDT
             They're fun to find. - (static) - (5) - Sept. 6, 2002, 08:56:37 AM EDT
                 Re: They're fun to find. - (deSitter) - (4) - Sept. 6, 2002, 10:00:51 AM EDT
                     Why not? - (ben_tilly) - (2) - Sept. 6, 2002, 10:37:47 AM EDT
                         Re: Why not? - (deSitter) - (1) - Sept. 7, 2002, 09:22:45 AM EDT
                             Wrong answer (long) - (ben_tilly) - Sept. 7, 2002, 03:31:29 PM EDT
                     I shouldn't ought hafta to do what? - (static) - Sept. 7, 2002, 03:27:22 AM EDT
             There's that exposure thing happening agin..... ;) -NT - (folkert) - Sept. 6, 2002, 09:32:01 AM EDT
         Perhaps it's related to Qwest and sundry... - (Another Scott) - (1) - Sept. 7, 2002, 11:07:30 AM EDT
             Re: Perhaps it's related to.... - (folkert) - Sept. 7, 2002, 08:58:18 PM EDT

Listeners, the City Council, for national security reasons, have replaced the following report with the sound of a burbling brook, followed by the sound of a running blender.
49 ms