Re: Accessing A Large MS SQL Table Over ADO Components

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 10/11/04 

Date: Sun, 10 Oct 2004 20:31:46 -0500

>We will be developing a large database application and currently we are
>working on some base forms and planning the architecthture.
>
>An avarage table will be holding around 1000000 records in our application.
>
>If we want to display the data on a readonly grid wich component is the best
>to use, TADODataSet or TADOQuery ?
They essentially do the same thing but TadoDataset has properties that are a bit
better fit to ADO

>What about if the grid is not readonly?
What is the question?

>And I want to know, if I use a standart DB Grid, does the dataset component
>fetches all the records to client?
Yes

>What about the cursor location. Setting the cursor to serverside has any
>advantages? Because I had some performance loss when I set it up to Server
>Side?
If you have a very large number of records you want to fetch and very few users
on your SQL server the severside cursors can perform better.

>And also ADO Components are a good choice?
Yes 

--
Brian Bushay (TeamB)
Bbushay@NMPLS.com

Relevant Pages

  • Re: Strange Recordset/Query Problem
    ... > display in SQL Server. ... table names for each field in the SELECT clause, ON clauses, and WHERE ... Also, SQL Server is not case sensitive, so you can save your eyes by using ... the IF statement executes the first condition as it should, ...
    (microsoft.public.inetserver.asp.general)
  • Strange Recordset/Query Problem
    ... Access 2000 database to a SQL Server 2000 database. ... display in SQL Server. ... the IF statement executes the first condition as it should, ...
    (microsoft.public.inetserver.asp.general)
  • MSHFlexgrid not displaying data from ADO data control
    ... if I put it onto a clients machine none of the ... MSHflexgrids display any data. ... The MSHflexgrids data sources are ADO data controls which are ... The SQL Server uses windows network authentication to allow access and I ...
    (microsoft.public.vb.general.discussion)
  • Re: Text below an image
    ... > sql server db underneath the image. ... > So you have a picture and underneath its dimensions. ... load it from there into the image class. ... >> Im gonna display a list of images in an aspx page from sql server Db.Each ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: FTS query performance on SQL 2005
    ... Basically what i do is bank on the fact that it is rare for most people to ... believe this is because the full resultset is returned from the FTE back ... SQL Server, and then the count is taken on that. ... but I'd like to also display "Showing results ...
    (microsoft.public.sqlserver.fulltext)