You are here: Re: [newbie] How to minimize DB load? « PHP Programming Language « IT news, forums, messages
Re: [newbie] How to minimize DB load?

Posted by David T. Ashley on 12/06/06 17:17

That is the standard rule. The largest improvements are algorithmic ...
once that is set, the rest is nickel and dimes and will almost never give
more than a 2x improvement when all the nickels and dimes are added
together.

"Willem Bogaerts" <w.bogaerts@kratz.maardanzonderditstuk.nl> wrote in
message news:4576734a$0$335$e4fe514c@news.xs4all.nl...
> If you'd use a database too much, I suspect it gives a huge load. My
> first guess is that you try and see if the database itself is properly
> organized, especially if the necessary indexes exist and are used.
> Further optimization is possible (like caching), but will generally not
> have that huge an impact.
>
> Best regards
>
> Vincent Delporte wrote:
>> Hi
>>
>> A friend is running a community application in PHP on a shared
>> server, and his provider is complaining that it's using the DB too
>> much.
>>
>> Apart from making changes to how data are organized in the DBMS, are
>> there ways in PHP to minimize DB load, eg. caching data instead of
>> reading/writing them from/to the DBMS every time, etc.?
>>
>> Thank you.

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация