SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Addict
    Join Date
    Jan 2004
    Location
    Nashville
    Posts
    335
    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 gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,273
    Mentioned
    60 Post(s)
    Tagged
    3 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
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Addict
    Join Date
    Jan 2004
    Location
    Nashville
    Posts
    335
    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
    335
    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 longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 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
  •