calling query from memory?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Hermes (nospam_at_nospam.com)
Date: 11/19/04 

Date: Fri, 19 Nov 2004 00:24:59 +0000 (UTC)

Hi All,

Is there a way of performing an sql query and then call it again from memory
rather than having to execute the query again?
As We have a few pages which gets data from a long query but then depending
on user interaction could get recalled several times but with the data still
the same.

Kind regards,
Hermes

Relevant Pages

  • Re: fatal memory error after executing query on MSSQL server
    ... > Is the message I get when I execute a select query on a MSSQL database. ... 30MB is quite a lot of memory for a simple script to need -- ...
    (alt.php)
  • Re: Finally which ORM tool?
    ... manipulate the linq query IF you're executing it at that moment. ... simply because the declaration construction was with 'CHOPS'. ... implement IEnumerablebut had an Execute() method which gave back ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: SQL stored procedure executing twice
    ... I wasn't aware that DLookupwould execute the "domain" more than once. ... caused the stored procedure to execute twice. ... Dim stDocName As String ... My pass-thru query properties ...
    (microsoft.public.access.modulesdaovba)
  • Re: Clarification on DBI module
    ... You get the same results for the second execute because the record buffer in the statment handle is not cleaned out because no execute took place. ... The sql query can have bind variables or they may not have. ... Ahhh...imagining that irresistible "new car" smell? ...
    (perl.dbi.users)
  • RE: Running action function from SELECT query
    ... Yes ADO can execute queries saved in an Access database. ... I do not know how ADO.NET works, but the developer tells me he is able to ... At any rate, I can call just a function from a query, like this: ...
    (microsoft.public.access.modulesdaovba)