Re: limits of SQL Server???
From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 02/18/04
- Next message: Bruce Martin: "Should I delete the NT/Admin's group in SQL Server 2k"
- Previous message: Dejan Sarka: "Re: Upgrading Server to 2003 - Any Issues with SQL??"
- In reply to: mickey: "Re: limits of SQL Server???"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 18 Feb 2004 06:34:54 -0600
Great. I suspect that the problem has more to do with your method of data access/retrieval/display than with SQL Server.
Running this statement within Query Analyzer displays the 2155 rows in 0 seconds:
use northwind
go
select * from Invoices
-- Keith "mickey" <newslist@REMOVEMEmicnap.com> wrote in message news:%23Vuam1N9DHA.712@tk2msftngp13.phx.gbl... > 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. > > > > > >
- Next message: Bruce Martin: "Should I delete the NT/Admin's group in SQL Server 2k"
- Previous message: Dejan Sarka: "Re: Upgrading Server to 2003 - Any Issues with SQL??"
- In reply to: mickey: "Re: limits of SQL Server???"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
