DDRFreak going haywire!! The Apocalypse!!1

Shen · Trick Member Joined: 04 May 2002 Location: TN

Cool. Thanks, I just wanted to know if it was just me or not.

MPB3.Radio · Trick Member Joined: 05 Dec 2002 Location: P-Town

phpBB itself is optimized for MySQL, while I understand that PostgreSQL is reasonably faster under heavy loads. Has anyone actually optimized the SQL queries that the board makes? The pgsql driver that phpBB uses is rather hackneyed.

The forum jump drop menu can also contribute a lot of strain.

J Dogg · Administrator Joined: 16 Jan 2002 Location: Sunnyvale, CA

Cutriss · Staff Member Joined: 24 Jan 2002

Does the menu execute a query every time a pageload is executed, as opposed to using static/cached content? To check for new forums to add to the list?

I imagine that's one of the first things that would've been cached, as it changes very infrequently (like less than once every six months)...
_________________

Sentient Mode is capable...

J Dogg · Administrator Joined: 16 Jan 2002 Location: Sunnyvale, CA

I looked at the jumpbox code, and I realized there are a ton of SQL queries in utility functions that could use caching. Thanks for pointing these things out to me. Also, the difference between caching every 5 minutes and every 6 months is extremely minimal. The biggest difference caching makes is changing it from something like 50 concurrent queries at any given time to once every so often (like 5 minutes, or even 1 minute), which frees up a tremendous amount of processing power.
_________________

MPB3.Radio · Trick Member Joined: 05 Dec 2002 Location: P-Town

The dropbox output itself could be cached for the various combinations of user privileges and groupings. The cached outputs would be updated whenever a change is made to the forum/category organization.

B4ULoveShine · Posted: Sun Mar 14, 2004 12:25 pm Post subject:

Now this is strange:

When I logged in for the second time around and going to respond on this topic, it ended up prompting me to log in.

This is the 2nd time around that happened to me.
_________________

BeForU was easily the heart and soul of DDR, until someone in Konami thought that it's a threat to the current structure (read: Konami's blatant overfunding of IIDX/pop'n).

J Dogg · Administrator Joined: 16 Jan 2002 Location: Sunnyvale, CA

J Dogg · Administrator Joined: 16 Jan 2002 Location: Sunnyvale, CA

Ok, I just implemented caching for a bunch of utility functions, including the jumpbox stuff. The forums should be running a lot faster during peak times, and for unregistered users, it should be extremely fast, since there's even less processing to be done.
_________________

Cutriss · Staff Member Joined: 24 Jan 2002

I had a thought last night -

Do index.php and viewforum.php run a separate query on pageload to determine who the forum moderators are?
_________________

Sentient Mode is capable...

Agilab · Contributor Joined: 10 Mar 2003 Location: Baltimore, MD

I've found that loading the forums is the slowest part, but once I can get to the forum index it runs smoothly.
_________________

Cutriss · Staff Member Joined: 24 Jan 2002

J Dogg · Administrator Joined: 16 Jan 2002 Location: Sunnyvale, CA

Cutriss, I'll look into it. Something I've noticed is that phpBB uses a lot of giant queries with lots of nested SELECT statments to do stuff. Lots of those queries contain information that rarely change. If I could split them out and cache the results of the queries that rarely change, that would probably save some time.
_________________

dreamdancer · Posted: Tue Mar 23, 2004 11:34 am Post subject:

I have gotten:

Warning: pg_connect(): Unable to connect to PostgreSQL server: could not connect to server: Connection refused Is the server running on host "hydrogen.ddrfreak.com" and accepting TCP/IP connections on port 5432? . in /home/ddrfreak/www/www.ddrfreak.com/data/phpBB2/db/postgres7.php on line 80
phpBB : Critical Error

Could not connect to the database

at least 20 times today

_________________

Click to see my NNR scores