Re: limits of SQL Server???

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: mickey (newslist_at_REMOVEMEmicnap.com)
Date: 02/16/04 

Date: Mon, 16 Feb 2004 17:33:48 -0500

Keith and Andrew,

I am swamped with some other stuff right now but will get back to this
project towards the end of the week.

I just wanted to post and thank you guys for taking the time to help me out.
I am not ignoring your posts.

Once I get a chance to sit down and look at this again and go through your
suggestions I will report back.

THANK YOU!!!!!

Mickey

"Keith Kratochvil" <sqlguy.back2u@comcast.net> wrote in message
news:e6TVb2L9DHA.440@TK2MSFTNGP10.phx.gbl...
I asked this information last time but did not receive a response. I will
re-post my questions to you:

In addition to the other posts, your speed/performance issues might be
outside of SQL Server.

>From Query Analyzer:
run the query/stored procedure that populates the page
Does the data come back quickly from the database?

Perhaps the "problem" is the way that the page is rendered within your .asp.
How can you speed up the process? Have you tried dumping the data to a
simple page via response.write (don't worry about formatting for now). Is
the page created any faster? 

-- 
Keith
"mickey" <newslist@REMOVEMEmicnap.com> wrote in message
news:%23WTwbc18DHA.1504@TK2MSFTNGP12.phx.gbl...
> I am setting up an "expanded view" of all the categories of products
> available in a shopping cart system.  The list pulls all the categories
from
> the database in groups.  See http://www.micnap.com/cart/tek9.asp.  This
page
> is really slow to load.  I assume the problem is caused by trying to pull
> about 400 things from the database because when I switch to using a
database
> with only a few records, it's fine.
>
> So....my question is....
>
> What is the generally accepted limit of # of items that can be pulled from
> SQL Server without slowing down the page load?  Am I just asking too much
> with 400 items?
>
> Thanks,
> Mickey
>
> P.S.  I realize that it is pulling the 400 categories twice because it's
> also putting them into a dropdown box in addition to the list but it's
still
> slow with just the list.
>
> P.S.S.  And no, they do not want the list as their main navigation for
their
> shopping cart.  The list is too long.  They want it as an added feature
for
> people that know exactly what they are looking for.  The link is just a
demo
> page.
>
>

Relevant Pages

  • RE: To: Beetle, BruceM & the Access newsgroup
    ... a database. ... I have seen this expressed in other posts as well. ... I kept coming back to the newsgroup, sometimes to ask questions, ... your tutorial is right on the mark here!). ...
    (microsoft.public.access.gettingstarted)
  • Re: Generating one table with a terabyte of data
    ... I didn't know we could split a database file group over multiple HDs. ... > Run perfmon counters to a log and analyze them after a bulk load. ... Another thing is to split the updates across file sets. ... >> loading of daily data in the fastest time. ...
    (microsoft.public.sqlserver.dts)
  • Re: ORACLE RAC and ORACLE Standby
    ... standby is better for disaster recovery and RAC is ... with taking any downtime on your primary database instance. ... The standby database provides a local or off-site recovery instance. ... Load balancing capabilities of RAC include ...
    (comp.databases.oracle.server)
  • Re: Poser? What happens to empty pages in a database unload/load?
    ... At my company, several time each weekend, a database is unloaded at ... squeezed out of the load. ... I unload the table and load it back and now all those empty pages are ... Art S. Kagel ...
    (comp.databases.informix)
  • Re: Too many objects loaded at the same time and cause OutOfMemory exception.
    ... Stored procedures won't necessarily help here, ... allow the database to pre-plan the implementation. ... There should be a way to load objects without having to load all ... each student has 5 lessons. ...
    (microsoft.public.dotnet.framework.aspnet)