Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Fewer, but larger queries/statements. Think about the query to add any indexes that may help.

Less concurrency may help. I bet you have deadlock problems with high continuous writes and deletes... maybe you can queue or otherwise delay your writes and then insert with a single thread...

Use a lower transaction isolation level if possible.



Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: