Updating Database At Regular Intervals

Discussion in 'Databases' started by nh_capricorn, Sep 5, 2004.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. nh_capricorn

    nh_capricorn

    Is there a way to update my database at regular, small intervals (say every 15 seconds)? I was looking at a number of FTP tools to do this, but the smallest time increment they have is one minute. Are there any other tools that provide this type of fine control?

    If not, what is the best way to do this?

    Thanks!
     
    nh_capricorn, Sep 5, 2004
    #1
  2. Scott

    Scott

    When you say "updating", what is it, exactly that you want to do. Are you adding, deleteing, or changing data every 15 seconds?
     
    Scott, Sep 5, 2004
    #2
  3. Bruce

    Bruce DiscountASP.NET Staff

    If you are trying to replace the MS Access file in like a 15 s interval, i do not recommend it.

    You will run into so much locking problem that either your FTP or web application will fail.

    Remember, Access and file based db (text) uses lock to maintain integrity. ie. if something has the db open, other application cannot overwrite it.

    quote:Originally posted by nh_capricorn

    Is there a way to update my database at regular, small intervals (say every 15 seconds)? I was looking at a number of FTP tools to do this, but the smallest time increment they have is one minute. Are there any other tools that provide this type of fine control?

    If not, what is the best way to do this?

    Thanks!
    </blockquote id="quote"></font id="quote">

    B.

    DiscountASP.NET
    http://www.DiscountASP.NET
     
    Bruce, Sep 6, 2004
    #3
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page