Database structure for tracking downloads?

  • Resolved mattheinrich

    (@mattheinrich)


    7 years, 4 months ago

    I have a client who needs to regularly count the total downloads of each document. They have hundreds of documents so summing the totals is not efficient.

    I thought maybe I’d write an SQL query to return a list of the total downloads for each of the mdocs.

    Do you think this is feasible? If so, where can I find the number of downloads per mdoc in the DB?

    Thanks,
    Matt Heinrich

Viewing 1 replies (of 1 total)
  • Plugin Author bhaldie

    (@bhaldie)

    unfortunately there is no easy way to do that the data is all in a serialized array inside the database and with unserializing all the data is pretty much useless.

Viewing 1 replies (of 1 total)
  • The topic ‘Database structure for tracking downloads?’ is closed to new replies.