Form refresh when activating a ADOQuery


I am activating an ADOQuery against a very large database. The response time for the query sometimes takes as long as 20 minutes.
During the time between activating the query and getting the result set, the application form will not refresh and any screen content that overlays it leaves a corrupted (not updated) screen area where the form was origainally located. I have tried various ways to allow the form to refresh normally (asynchronous connections, server side cursors, timers, threads, etc.) but nothing seems to work.

Has anyone solved this problem? If so, would you mind sharing the solution?

TIA

.

Relevant Pages

  • Re: Issue with a table that is 75%-80% of the database size
    ... SQL Server 2000 does not support table partitioning. ... Have you tried database differential backup? ... your query response time and backup time. ...
    (microsoft.public.sqlserver.server)
  • Re: Form refresh when activating a ADOQuery
    ... > I am activating an ADOQuery against a very large database. ... > response time for the query sometimes takes as long as 20 minutes. ...
    (borland.public.delphi.database.ado)
  • One Question !
    ... The database has grown and query response time has slowed. ... should I create a new filegroup. ...
    (microsoft.public.sqlserver.clients)
  • Issue with a table that is 75%-80% of the database size
    ... Our database easily grows to a size over 250 GB and up. ... Users connect to the database through a Query application ... The concerns are to improve the response time for each ... How about partitioning a particulare table? ...
    (microsoft.public.sqlserver.server)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)