SitePoint Sponsor

User Tag List

Results 1 to 5 of 5

Thread: Display on site not updating

  1. #1
    SitePoint Addict
    Join Date
    Jan 2004
    Location
    Nashville
    Posts
    333
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Display on site not updating

    I have a mySQL db and when I make a change to the db the content on the site does not update until sometime later.

    Is there a setting that determines when the data actually shows up on the website? If so is this something I want to locate and change?

    Thanks

  2. #2
    SQL Consultant silver trophybronze trophy
    SitePoint Award Recipient r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    38,458
    Mentioned
    34 Post(s)
    Tagged
    1 Thread(s)
    mysql data does not appear on web pages unless there is some scripting language such as php, asp, jsp, coldfusion...

    i would investigate your specific installation to see if your language has some sort of web page caching in place
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Addict
    Join Date
    Jan 2004
    Location
    Nashville
    Posts
    333
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Does mySQL wait to write to the database?

    I thought it was just one application that I was using where updates to the database seemed like they took 3-30 minutes.

    But then I was in another application that uses mysql and I noticed the same thing. I tried refreshing the browser, even closed and opened it.

    The new data did not show up yet.

    Is there some kind of delay before data writes? Or is this an application by application thing. Some times I notice it and sometimes I don't.

    Thank you

  4. #4
    SitePoint Addict
    Join Date
    Jan 2004
    Location
    Nashville
    Posts
    333
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thank for your reply. The applications in question are like Joomla (Mambo) and a couple other systems in PHP

  5. #5
    reads the ********* Crier silver trophybronze trophy SitePoint Award Recipient longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    the application must be doing it. after a client writes the data to the db server, it's immediately available to the application.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •