issue_comments: 697835956

This data as json

html_url issue_url id node_id user created_at updated_at author_association body reactions issue performed_via_github_app
https://github.com/simonw/sqlite-utils/issues/172#issuecomment-697835956 https://api.github.com/repos/simonw/sqlite-utils/issues/172 697835956 MDEyOklzc3VlQ29tbWVudDY5NzgzNTk1Ng== 9599 2020-09-23T18:22:49Z 2020-09-23T18:22:49Z OWNER

I ran sudo py-spy top -p 123 against the process while it was running and the most time is definitely spent in .update(): ``` Total Samples 1000 GIL: 0.00%, Active: 90.00%, Threads: 1

%Own %Total OwnTime TotalTime Function (filename:line)
38.00% 38.00% 3.85s 3.85s update (sqlite_utils/db.py:1283) 27.00% 27.00% 2.12s 2.12s execute (sqlite_utils/db.py:161) 10.00% 10.00% 0.890s 0.890s execute (sqlite_utils/db.py:163) 10.00% 17.00% 0.870s 1.54s columns (sqlite_utils/db.py:553) 0.00% 0.00% 0.110s 0.210s <listcomp> (sqlite_utils/db.py:554) 0.00% 3.00% 0.100s 0.320s table_names (sqlite_utils/db.py:191) 0.00% 0.00% 0.100s 0.100s new (<string>:1) ```

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
 707427200