PDA

View Full Version : Article: Server issues.... the kicketh of the dead horse.



gideon
Mar 14, 2001, 09:46 AM
God writes, "Yes, as everyone notices even with the server upgrade at peak usage times, PSO World slows to speeds only a turtle, and very old people could love ;). Fear not! We are in the process of yet again searching for a host upgrade. We will be delivering our little site to you at regained speeds within a short time. Stick with us. "

NeiLast
Mar 14, 2001, 06:50 PM
THere are several features of the site that could be trimmed off the scripts to improve performance.
Most notably, tracking the views of the items in the item database and the posts in the forum eat away at performance in my experience.
You might be able to attain much better performance by removing a few such features that add a lot of overhead but are not that important of features anyhow.
I'm not sure exactly how you have your system setup, but caching the contents of any database queries for the first forum page for a couple minutes at a time should help a lot, and only make the number of posts, etc slightly less accurate.

Mar 14, 2001, 09:38 PM
You're right. I measured the time of each line from the main page as they arrived on my machine. The bottleneck seems to be the DB, most probably not the HTTP server or the scripting engine:

<tt>line seconds ...</tt>
000 6.83 &lt;html&gt;
072 13.99 &lt;li&gt;&lt;a href=viewpmsg.php&gt;P...Rare Items: Weapons...
100 0.11 &lt;table border=0 cellspacing=0 cellpa...End is Near...
127 8.45 ( &lt;a href="article.php?sid=237&mode=t...2 comments...
162 9.09 Posted by &lt;b&gt;&lt;a href="http://t...read: (64 times)...
239 15.96 Posted by &lt;b&gt;&lt;a href="http://...read: (312 times)...
259 14.81 &lt;li&gt;&lt;a href="article.php?sid=2...as a Force&lt;/a&gt; (7)...

The delays always seem to happen when there is a dynamyc content coming from the DB. Of course, this is only an assumtion since I don't know the implementation.