SharePoint stores customized site pages in the content database. So, suppose there are 1000's of pages which are created and modified by users (say by adding webpart), some are created and modified using SharePoint designer. All these will sit in the content db.
Isn't it performance issue. Because they need to be fetched from the database?