1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

[MySQL] Can I read from materialized view while refreshing it??

Discussion in 'Databases' started by Dr.Weed, Jan 21, 2018.

  1. #1
    Can I read from materialized view while it is in a process of refreshing?? Lets say query for the refresh take 2s and my website has, on average, a request per second. Will my site brake if I try to serve the request and materialized view is in process of refreshing????
    SEMrush
     
    Dr.Weed, Jan 21, 2018 IP
    SEMrush
  2. jestep

    jestep Prominent Member Premium Member

    Messages:
    3,640
    Likes Received:
    212
    Best Answers:
    18
    Trophy Points:
    330
    #2
    What sort of platform / language is site using?

    Typically a database request would block an HTTP request from being complete until it has completed, unless you're using javascript or another mechanism to update after the initial HTTP request has been complete.

    Really need to know more about how your site is programmed and how it is making HTTP and database requests to answer this correctly.
     
    jestep, Jan 22, 2018 IP