ADO & Initial Table Query


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: ADO & Initial Table Query

  1. #1
    Tony Ford Guest

    ADO & Initial Table Query


    How can I speed up the initial SQL query sent to a table?

    My problem lies in that my first query to a table takes 30 to 40 seconds
    to come back.
    However, subsequent queries only take a second or two. How can I speed up
    this first
    query or how can I 'hide' the time? I've tried executing the query at startup
    and was looking
    at running it in the background but haven't found any reasonable solution.

    Any ideas?




  2. #2
    Perry Forman Guest

    Re: ADO & Initial Table Query

    What is your backend. There's a possibility that whatever your doing is
    getting cached. So there is always the initial load time.

    PF

    "Tony Ford" <Tony.Ford@abi.org.uk> wrote in message
    news:38ec6581$1@news.devx.com...
    >
    > How can I speed up the initial SQL query sent to a table?
    >
    > My problem lies in that my first query to a table takes 30 to 40 seconds
    > to come back.
    > However, subsequent queries only take a second or two. How can I speed up
    > this first
    > query or how can I 'hide' the time? I've tried executing the query at

    startup
    > and was looking
    > at running it in the background but haven't found any reasonable solution.
    >
    > Any ideas?
    >
    >
    >




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center