It is quite possible that the queries and such are taxing the DB
server. Too many people use '*' in their queries as the easy way out.
This will slow down the search. If you don't need to display the
fields, don't include them in the search. As well, I have seen the case
where people use reams and reams of server side code (ASP, PHP, etc)
where a couple of lines of SQL will do the trick a lot faster. There
are many instances where the work is best left up to the database. As
well, you should use stored procedures whenever possible. You should
also make sure that your widely used tables are keyed and indexed.

jord

On Wednesday, October 30, 2002, at 01:11 PM, Robert J. wrote:

> I have been assigned as a project manager for a new site that our
> development team is working on and the client (and others) are
> complaining
> that the site runs much too slow. I have noticed that sometimes the
> site
> runs quite slow too. Mainly the navigation which is coming from the
> SQL DB.
>
> One of the people on our team suggested I speak to our host and ask
> them to
> force the internet wide propagation of new routing tables for the IP
> number.
> Our host told me that no router settings have been changed since the
> site
> had been established.
>
> I am wondering if the site is (specifically the SQL DB) is just not
> properly
> optimized.
>
> Feedback is appreciated!
>
--
Jordan L. Chilcott, President
Interactivity Unlimited
Guelph, Ontario
---------------------------------
Tel: (519) 837-1879
Cel: (519) 835-6628
eFax: (253) 276-8631

Dreamweaver Talk Administrator - mailto:dreamweaver-admin@blueworld.com

mailto:jchilcott@interactivityunlimited.com
http://www.interactivityunlimited.com
iChat/AIM: j1chilcott

Think DreamWeaver!


------------------------------------------------------------------------
List Administrator: <mailto:dreamweaver-admin@blueworld.com>
To Unsubscribe: <mailto:dreamweaver-off@blueworld.com>
Archives: <http://www.listsearch.com/dreamweavertalk.lasso>