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.

Storing ad impressions on a database

Discussion in 'Databases' started by nekowai, Mar 20, 2021.

0
  1. #1
    I'm trying to improve an integrated ad server on my site, problem is I have some 10 tables which need their ad impression counters updated.
    Those tables are constantly being read by the website users (ads, bids, units, sites...), and the remote ad processor is constantly writing to those tables resulting in wait times for the users using the interface.
     
    nekowai, Mar 20, 2021 IP
  2. sarahk

    sarahk iTamer Staff

    Messages:
    28,500
    Likes Received:
    4,460
    Best Answers:
    123
    Trophy Points:
    665
    #2
    Is this mysql?
    What table type have you got?
     
    sarahk, Mar 21, 2021 IP
  3. nekowai

    nekowai Well-Known Member

    Messages:
    256
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    130
    #3
    Innodb. I'm pretty much having a hard time separating the "hammer" (remote site hits) from the interface. If on one side writing the statistics in real time seems not wise, not doing it also raises other problems like having to write them all at once when batch events occur.
     
    Last edited: Apr 2, 2021
    nekowai, Apr 2, 2021 IP
  4. laci272

    laci272 Well-Known Member

    Messages:
    163
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    118
    #4
    It's hard to say without knowing your table / index structure
    How big are your tables?
     
    laci272, Feb 15, 2023 IP