Re: Timeout on my request!

First, check the estimated execution plan of your query and, if it's
possible, try to optimize it.
If you have already done that,
why don't you schedule your query to run in background each night (or
each hour) and save the results in a DB table?
At this point in your web page do a simple 'select' statement to show
the data...surely it'll be faster.


:-)



On Sep 6, 3:40 pm, "Mark Rae [MVP]" <m...@xxxxxxxxxxxxxxxxx> wrote:
"Smith" <Sm...@xxxxxxxxxxxxxxxx> wrote in message

news:uStcNbI8HHA.5712@xxxxxxxxxxxxxxxxxxxxxxx

It all depends on the kind of data you work with. We are looking at
scientifc data here.

Data is data is data, at the end of the day...

Some of our queries can span over several hours.

In which case, I would be considering a different architecture, as the web
simply isn't designed for this kind of delay between Request and Response...

Have you thought about maybe some sort of messaging system where queries are
queued up waiting to be processed, and then the results emailed to the user
maybe as a PDF...?

--
Mark Rae
ASP.NET MVPhttp://www.markrae.net


.

Relevant Pages

  • RE: automatic emails by Access
    ... (schedule the check with some scheduling software periodically). ... Within this query create a new ... off 3 month after the original date in the OriginalDateField. ... action within a macro, make sure the last action of the macro is to shut down ...
    (microsoft.public.access.gettingstarted)
  • RE: automatic emails by Access
    ... different queries to correspond to the three different due dates? ... are saying I'll need a query for each up coming date to have the db calculate ... (schedule the check with some scheduling software periodically). ... action within a macro, make sure the last action of the macro is to shut down ...
    (microsoft.public.access.gettingstarted)
  • RE: automatic emails by Access
    ... Wow, freakazeud, ... are saying I'll need a query for each up coming date to have the db calculate ... (schedule the check with some scheduling software periodically). ... action within a macro, make sure the last action of the macro is to shut down ...
    (microsoft.public.access.gettingstarted)
  • RE: automatic emails by Access
    ... One would be to use the Sendobject method. ... are saying I'll need a query for each up coming date to have the db calculate ... (schedule the check with some scheduling software periodically). ... action within a macro, make sure the last action of the macro is to shut down ...
    (microsoft.public.access.gettingstarted)
  • Re: Create New Records in a Table by Copying Existing Records
    ... has a set of records in this table and there is a "Master" set of records. ... I can create a query and/or ... 'This procedure will copy a set of schedule records ... NewAddress = Forms!Schedule!ComboAddressSelect.Value ...
    (microsoft.public.access.queries)