By theorichel on

Since last week my virtual server goes down because of memory problems. My host wants to sell me more memory ( I have 1 gig and the site has seldom more than 100 visitors at a time) and it juust seems a bit too much for me. The host also said: 'I did a quick check after the reboot and it appears the issue is with any site that uses a database to populate the web page. Those processes seem to be taking up a large amount of time. Getting your web designer to make the pages more efficient will help your issue. '.

How do I make my pages more 'efficient'?

Thanks

Theo Richel

⋅ Categories: Drupal 6.x

Comments

ayesh’s picture

ayesh commented

Obviously Drupal cannot live without the database. also, unlike other specific systems such as vBulletin, Drupal uses a large number of queries to build a page (vBulletin just uses 7-15 for a simple page view while Drupal can go very higher than this. use Devel module if you need to investigate)..

So caching modules come to rescue.
As you have a VPS, I think it would be a better solution to use Memcached. To my experience, it saves a LOT of page generation time and query rate.
and don't ignore your faults if you have some misconfigured memory-consuming views, blocks, etc.
you can also try modules like Boost to store static pages of the generated pages so second page request to a page can be shifted to the static copy.

What's new and changing in PHP 8.4

dbeall’s picture

dbeall commented

I use Boost on a shared host for over 10 Drupal 6 and 7 sites and it works very nice.

Something else to check is the tables in the database to see any over sized or large tables..
I have had to remove or uninstall the search module due to server load, seems to help a lot.

I usually export Drupal sites to a local server and mess with it to make it run better.