I’ve been going through the crufty and scary ptvDB.py looking for ways to improve performance. Armed with the trust profile and pstats modules, I cut polling time in half by removing redundant and unnecessary database hits.<\/p>\n
I then got the idea of generating a print statement every time I hit the DB, so I can see exactly what the database is doing during regular operation.<\/p>\n
The result is not always pretty:<\/p>\n
Basic article read: Ok that’s fine, we get the entry, any associated media, and then the read state.<\/p>\n What about an unread entry? Oops. It’s whacking the database three times for the entry data, and updates the whole feed as well. Time to figure out what I’m doing wrong!<\/p>\n","protected":false},"excerpt":{"rendered":" I’ve been going through the crufty and scary ptvDB.py looking for ways to improve performance. Armed with the trust profile and pstats modules, I cut polling time in half by removing redundant and unnecessary database hits. I then got the idea of generating a print statement every time I hit the DB, so I can … Continue reading “PenguinTV optimization”<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22,23,26,25],"tags":[],"_links":{"self":[{"href":"https:\/\/ywwg.com\/wordpress\/wp-json\/wp\/v2\/posts\/369"}],"collection":[{"href":"https:\/\/ywwg.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ywwg.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ywwg.com\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ywwg.com\/wordpress\/wp-json\/wp\/v2\/comments?post=369"}],"version-history":[{"count":0,"href":"https:\/\/ywwg.com\/wordpress\/wp-json\/wp\/v2\/posts\/369\/revisions"}],"wp:attachment":[{"href":"https:\/\/ywwg.com\/wordpress\/wp-json\/wp\/v2\/media?parent=369"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ywwg.com\/wordpress\/wp-json\/wp\/v2\/categories?post=369"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ywwg.com\/wordpress\/wp-json\/wp\/v2\/tags?post=369"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n
\nSELECT title, creator, link, description, feed_id, date FROM entries WHERE id=? (69443,) ok
\nSELECT id,entry_id,url,file,download_status,viewed,length,mimetype FROM media WHERE entry_id = ? (69443,) ok
\nSELECT read FROM entries WHERE id=? (69443,) ok<\/code><\/p>\n
\nSELECT title, creator, link, description, feed_id, date FROM entries WHERE id=? (67523,) ok
\nSELECT id,entry_id,url,file,download_status,viewed,length,mimetype FROM media WHERE entry_id = ? (67523,) ok
\nSELECT read FROM entries WHERE id=? (67523,) ok
\nUPDATE entries SET read=? WHERE id=? (1, 67523) ok
\nUPDATE media SET viewed=? WHERE entry_id=? (1, 67523) ok
\nSELECT read FROM entries WHERE id=? (67523,) ok
\nSELECT id,entry_id,url,file,download_status,viewed,length,mimetype FROM media WHERE entry_id = ? (67523,) ok
\nSELECT title, creator, link, description, feed_id, date FROM entries WHERE id=? (67523,) ok
\nSELECT id,entry_id,url,file,download_status,viewed,length,mimetype FROM media WHERE entry_id = ? (67523,) ok
\nSELECT read FROM entries WHERE id=? (67523,) ok
\nSELECT feed_pointer,description FROM feeds WHERE id=? (233,) ok
\nSELECT id,title,fakedate FROM entries WHERE feed_id=? ORDER BY fakedate DESC (233,) ok
\nSELECT id FROM entries WHERE feed_id=? (233,) ok
\nSELECT feed_pointer FROM feeds WHERE id=? (233,) ok
\nSELECT pollfail FROM feeds WHERE id=? (233,) ok
\nSELECT feed_pointer FROM feeds WHERE id=? (233,) ok
\nSELECT read FROM entries WHERE feed_id=? (233,) ok
\nSELECT id FROM feeds WHERE feed_pointer=? (233,) ok
\n<\/code><\/p>\n