Re: Ado SQL Concept question.

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 03/06/04 

Date: Fri, 05 Mar 2004 22:29:49 -0600

>At this point I'm just 'stress' testing that area of my code. Since each
>user will make their own indepenent requests, I don't see how I can cashe
>the data ahead of time. Once I get on a real database server (does MSDE
>count), I will try using stored procedures - would they help?
>
>Basically my application will need to pool the database connection, and
>serve internet users (web browsers). I have been allowed a request time of
>50ms for a single lookup. Each user/session may request information about
>any record in the database. So I'm trying to optimized the lookup area of
>my code. This lookup uses a file of only 153,000 records (100+ megs) and
>is only changed once a month. This is the simplest part of the application,
>other tasks will require multi-table lookup (joins) and multi-item
>(multi-point) - but I have 'lots' more time for those 200ms... LOL.
The answers to this is going to vary according to the database you are using.
For Access using serverside cursors in TableDirect mode and using the SEEK
method to find a record instead of a Query should be fastest way to do a lookup.

For SQL server (MDE) a query will be best.
>Oh, one key point I just thought of - this is always only READ operations -
>cursor type, maybe?
Cursor type can be forward only if you only need readonly but that won't get you
much when you are doing just single records selects.
SQL server does some tuning on the queries that get run so it can pick up some
speed
MSDE has a limit of 5 simultaneous processes so it won't be good for this
application if it gets a heavy load or records to select. 

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

Relevant Pages

  • Re: Using SQl to store aspx pages and memory problems
    ... I've seen classic ASP applications design this way that work ... database isn't some sort of magic pixie dust that solves all problems. ... > the memory increases - the slowness of the request could be dealt with by ... >> takes to get the page from SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: connection to ado.net object
    ... The vb.net code will that submit the request for data to the hp> mainframe by using http and xml. ... This will somehow need to> include a connection object and statements oh how to connect to the SQL> server 2000 database. ... The user name and password are suppose to be passed to> the sql server as part of the connection string. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL Server 2000 and Latching problem
    ... Here is a brief definition of what latches are used for by Tom Davidson: ... > as the clients could talk to the database directly. ... > anything if the SQL server is dedicated or not. ... > than translate the original ISAM request. ...
    (microsoft.public.sqlserver.connect)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)