Re: Ado SQL Concept question.

From: RPM (rick_at_tariffnet.com)
Date: 03/05/04 

Date: Fri, 5 Mar 2004 11:43:48 -0500

Hi Brian,

> Why do you have to do single field lookups in a repetitive manner?
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.

Oh, one key point I just thought of - this is always only READ operations -
cursor type, maybe?

Relevant Pages

  • Re: PHP Design tools? IDE?
    ... In article, Tim Tyler wrote: ... >> The fileserver has to do a lookup anyways, to map the request to the ... >> controller script. ...
    (comp.lang.php)
  • Re: ASP.Net Caching Questions
    ... your assertion about Cache vs. database speed. ... Essentially, this is not a website, it's an application server. ... and then process the request as fast as possible. ... When I say as fast as possible I mean: if each lookup takes ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: db design questions
    ... I took your and the experts advice and dropped the lookup in the table ... I check a lookup table that checks the type and studio ... and attempts to autofill. ... is a request table with a 1 requestid and a second field requesttext. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: db design questions
    ... I don't know what studioname is in the ... I took your and the experts advice and dropped the lookup in the table ... and attempts to autofill. ... is a request table with a 1 requestid and a second field requesttext. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: How do I remove the #div or N/A and make it 0 when using VLookup?
    ... Vaya con Dios, ... > your formula should do exactly what you request and it works when i test ... > you click on the cell with the formula and use tools / formula auditing / ... >> I am using the results of the lookup for another calculation, ...
    (microsoft.public.excel.worksheet.functions)