[development] Query about new page

[Larry Garfield]

On Friday 31 July 2009 3:25:57 am Ankur Jain wrote:
> i just wanted to know why drupal is saving all the page content in database
> .. if we have many pages then it may slow down the database and also page
> loading.

The rest of the replies in this thread are valid, but I think right here is 
your first mistake.  In a properly designed database, the performance difference 
between 5 pages, 5000 pages, and 50,000 pages stored in the database is almost 
unmeasurable.  Just saving lots of pages in the database is not itself going 
to slow down your database or page loading unless you're doing something very 
stupid with your database.  Drupal's default database usage is, while not 
completely optimal, at least fairly good especially given the flexibility it 
has.  Once you've made the decision to store one page in the database (which 
you have by using Drupal at all), the added cost of storing the next 10,000 
pages in the database is virtually nil.

Now, if you're loading a lot of different page requests per second because it's 
a high traffic site, then you start dealing with performance questions.  
However, that depends on the number of requests you have, not the number of 
pages you have.  You're trying to optimize the wrong thing.

-- 
Larry Garfield
larry at garfieldtech.com