|
|
Posted by Jerry Stuckle on 11/19/72 11:46
windandwaves wrote:
> Jerry Stuckle wrote:
>
>>windandwaves wrote:
>>
>>>Shaun wrote:
>>>
>>>
>>>>On Sat, 29 Apr 2006 13:40:42 +1200, "windandwaves"
>>>><winandwaves@coldmail.com> wrote:
>>>>
>>>>
>>>>
>>>>>Hi Folk
>>>>>
>>>>>I am managing a site, www.friars.co.nz that seems to be hitting the
>>>>>limits and I keep getting the 500 error. According to the people
>>>>>from webfarm it is because my script are too demanding or not
>>>>>closed properly.
>>>
>>>
>>>
>>>Hmmm, yes, we have only about 10,000 unique visitors per month and a
>>>relatively straight forward MySql database. However, we have shared
>>>hosting, I think that is where the problem lies....
>>>
>>>Thanks for your reply
>>>
>>>
>>>
>>>>Nicolaas
>>>
>>>
>>>
>>10K visitors a month and an 80Mb database are nothing. Any shared
>>host should be able to handle that, also.
>>
>>If you think it's a problem, talk to your hosting company. Maybe the
>>server you're on is overloaded and they will move you to a less
>>heavily loaded server.
>>I'm not familiar with webfarm - but they may be right, also. For
>>instance, if you don't close your mysql connection, it will be closed
>>eventually. But the connection will hang around until the garbage
>>collector gets around to cleaning things up.
>
>
> I will do a close database connection at the end of each script and see if
> it makes a difference.
>
>
>>And look at how efficient your code is. I've seen some pretty good
>>code - but I've seen some very inefficient code out there, also. And
>>the inefficient code will require a lot more resources.
>
>
> It is so hard for me to judge if the code is efficient. Really - who knows.
> I know what efficient code is, but there are just so many variables. Even
> making changes tot the php.ini could be huge.
>
> Each page loads about 100Kb of libaries and functions... (probably 50 - 100
> functions (small ones) in total)... Does that make a difference?
> I have a couple of tables in the database with over 300,000 (small) rows)...
> Does that make a difference?
> I use a lot of session variables (i.e. I keep a log of each page visited for
> each person), but all of them are stored in highly optimised Mysql tables
> (e.g.
>
> person ID, page ID, time
> person ID, page ID, time
> person ID, page ID, time
> person ID, page ID, time
>
> In the end, because it is such muddy water, it is probably cheaper to pay
> for a dedicated server than to spend hours optimising your code. I can do
> fast development and write code in such a way that it is easy to maintain.
>
> Thanks for your reply. Much appreciated.
>
>
>>Nicolaas
>
>
>
>
Well, if every page is loading unnecessary functions, then yes, that will add
overhead. PHP has to parse all that code. I tend to break my functions in to
groups, and only load those which are necessary for the page.
The database itself isn't a problem. However, your access to the database could
be inefficient. For instance, you may be doing full table scans when the
appropriate index could allow an index scan. But that is all very dependent on
your the RDB you're using, database layout, the actual operations you're
performing on it and about a dozen other variables.
I wouldn't think session variables would have a huge effect on it, but it's also
possible. However, I would also look at what you're doing. Can you get
basically the same information from your Apache log?
Yes, it will take time to make it more efficient. But I think it would be worth
it. And a dedicated server has its own additional overhead for maintenance.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|