Speeding up retrieval for CMS system

Document Sample
Speeding up retrieval for CMS system Powered By Docstoc
					                                  Speeding up retrieval for CMS system

Speeding up retrieval for CMS system

Source:
http://www.tech−archive.net/Archive/Internet−Server/microsoft.public.inetserver.asp.db/2006−08/msg00105.html



      • From: <programmingcodeATjards.com>
      • Date: Fri, 25 Aug 2006 16:00:13 −0400

I create a content management system using SQL Server and ASP that uses 2
tables, content and categories. Structure listed below:

content
contentID identity int
categoryID foreign key (int)
Title varchar(100)
Body text
status char(1)

category
categoryID identity int
categoryname
description
status

Now I have a database that has over 10 categories and content table has over
150 records. Problem, getting record for display has slowed tremendously.
It used to be fairly quick when obtaining records, now it takes about 1
minute (to load from webpage not sql server). I use stored procedures to
get pages using this proc :

CREATE PROC DBO.SHOWCONTENT
@CONTENTID INT, @CATEGORYID INT
AS
SELECT *
FROM CONTENT
WHERE ContentID = @CONTENTID AND CategoryID = @CATEGORYID
ORDER BY Content.categoryid, content.contentid
GO

Users access the system from links that have the ContentID and CategoryID
parameter. I have no indexes as I thought it may slow down the system since
I control the inserting of data in the system. There are default indexes
created by system for the primary key and foreign key constraints.

How can I speed up the retrieval process of this system? Any and all help
will be greatly appreciated!!!


Speeding up retrieval for CMS system                                                                   1
                             Speeding up retrieval for CMS system



.




Speeding up retrieval for CMS system                                2

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:4
posted:12/30/2011
language:
pages:2