innocent-team/isucon13 issues and pull requests

#57 - トランザクションほぼ全部剥がす

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#56 - statsでトランザクション剥がしたい

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#55 - トランザクション剥がしまくる

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#54 - トランザクションやめてまわる

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#53 - JOINしなくていい

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#52 - トランザクション剥がす

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#51 - LivestreamModelをキャッシュ

Pull Request - State: closed - Opened by utgwkk about 1 year ago - 1 comment

#50 - UserModelを2秒キャッシュ

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#49 - アイコン画像のハッシュをusersテーブルに非正規化する

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#48 - 配信のタグを非正規化

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#47 - Livestream tags foreign key

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#46 - こっちも

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#45 - 予約可能かどうか見るときにCOUNTだけ見る

Pull Request - State: closed - Opened by utgwkk about 1 year ago - 1 comment

#44 - スパム判定やめてみる

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#43 - go-json

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#42 - livestream_tagsを複合主キーにする

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#41 - themeを非正規化

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#40 - 外部キーやめる

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#39 - アイコン画像をnginxから配信する

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#38 - DNS TTL 60

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#37 - 古いスパムの削除はreq.NGWordに対してだけやればよい

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#36 - トレーシング切る

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#35 - ロック獲得する時間を短くしたい

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#34 - 使ってないlivestreamsがあるやん

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#33 - NGワードのクエリの条件を削る

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#32 - スパマーを弾く

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#31 - アイコンをUPSERT

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#30 - チップを投げない人だけスパム判定しておく

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#29 - インデックス調整

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#28 - bulkFillLivestreamCommentResponse

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#27 - GOGC=600

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#26 - iconのキャッシュ秒数を伸ばす

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#25 - アイコンのキャッシュでsync.RWMutexを使う

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#24 - アイコンハッシュのキャッシュをもっと使う

Pull Request - State: closed - Opened by utgwkk about 1 year ago - 1 comment

#23 - タグ検索でクエリしない

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#22 - ログ消す

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#21 - 配信のタグをbulk insert

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#20 - bulkFillReactionResponse

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#19 - Revert "Bulkfill reactions"

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#18 - 予約枠の残数をアプリケーション側でのみチェック

Pull Request - State: closed - Opened by utgwkk about 1 year ago - 1 comment

#17 - Bulkfill reactions

Pull Request - State: closed - Opened by utgwkk about 1 year ago - 1 comment

#16 - Ngword check

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#15 - Bulkfill2

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#14 - Bulkfill

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#13 - Livecomment n query

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#12 - ICONをキャッシュするよ

Pull Request - State: closed - Opened by wass88 about 1 year ago

#11 - Revert "DBの統計情報を見れるようにする"

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#10 - DBの統計情報を見れるようにする

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#9 - 配信のランクも1クエリで取る

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#8 - タグを静的にしちゃうよ

Pull Request - State: closed - Opened by wass88 about 1 year ago

#7 - Stats nantokasuru

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#6 - iconのhashを計算してDBに入れるよ

Pull Request - State: closed - Opened by wass88 about 1 year ago

#5 - fillLiveStreamもbulkのほうで処理 tagがN+1してた

Pull Request - State: closed - Opened by wass88 about 1 year ago

#4 - DBを落として外部キーをつける

Pull Request - State: closed - Opened by wass88 about 1 year ago

#3 - NGワードにヒットしたコメントを一括で消す(moderate)

Pull Request - State: closed - Opened by wass88 about 1 year ago

#2 - searchLivestreamsHandlerのN+1クエリ

Pull Request - State: closed - Opened by utgwkk about 1 year ago

#1 - トレーシング

Pull Request - State: closed - Opened by utgwkk about 1 year ago

GitHub / innocent-team/isucon13 issues and pull requests