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 [email protected]
