Welcome to Geeklog, Anonymous Wednesday, April 17 2024 @ 10:19 pm EDT

Geeklog Forums

Caching of the Geeklog


Status: offline

Remdotc

Forum User
Chatty
Registered: 06/12/02
Posts: 55
Anyone else besides me intrested in caching geeklog db queries in order to increase speed? Dont get me wrong, I think GL rocks, but it is extreamly process intensive. Taking 3-5 seconds to create a page, even on the main geeklog site. (I have tried a Duel Pentuim 4, running RH linux, 8,0 with custom compiled apache+php) with 1 Gig of Mem , scsi hard drive and still get results that average out at 3.4 seconds. Anyone use or have tried a caching engine?
 Quote

Anonymous

Anonymous
Are your tables indexed?
 Quote

Status: offline

mvonahn

Forum User
Newbie
Registered: 09/09/02
Posts: 3
Make sure you have all your indexes set up properly. I have a GL site (www.macfixit.com) with a user list of 120k+ and almost 10k articles that produces pages in .5 - 1 second. System is a dual 1g p3 with 1g ram. The biggest delay in page load that I have found is the user Authentication stuff that happens at the top of the pages. mva
 Quote

Anonymous

Anonymous
I agree. Check your table indexing first because if it's not set up right that will slow you down big time. The other thing I did, which probably will make Dirk cringe, is remove all the excess indenting spaces in templates. Those aren't needed in displaying your pages. By doing this, my webpages are about 50% lighter.
 Quote

jhoke

Anonymous
Another thing to try is have a cronjob hit your page every 1/2 hr or so, this keeps any time based pages (weather, qotd ,etc) updated in a timely basis... I have also had good luck with the PHPAccelerator http://www.php-accelerator.co.uk/ Food for thought-----John http://www.slapd.net http://john.hoke.org
 Quote

Anonymous

Anonymous
Macfixit loaded the main page in like 10 sec, but the forum loaded really quick. Im on a T1 line P4 2.0 CPU win2k machine
 Quote

Status: offline

EKwant

Forum User
Junior
Registered: 09/29/02
Posts: 19

I just installed the PHP Accelerator for a short while on my GL server, and was impressed with it. Shaved quite a few hundreths of a second off my generation times.

Only problem I found was I got a weird SQL syntax error 1064 when viewing my Andromeda MP3 script, which is wrapped in GL. So I disabled the Accelerator for now.

EKwant
www.kwantum.net

 Quote

All times are EDT. The time is now 10:19 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content