Dev help needed: improving DB throughput

Anything to do with the Pale Moon Sync service.
User avatar
Moonchild
Project founder
Project founder
Posts: 39713
Joined: 2011-08-28, 17:27
Location: Sweden

Dev help needed: improving DB throughput

Post by Moonchild » 2016-01-06, 01:39

Maybe someone on the forum here is fluent in SQL who can help.

The issue is that DB updates for Sync are too expensive at the moment (we use InnoDB to prevent table locking issues, but it has its own limits...).
Details in the following issue: https://github.com/MoonchildProductions ... S/issues/4

If anyone SQL-savvy can help out with changing the statement properly... that would be awesome
"Sales hates anything that can't be turned into a confident sentence." - anonymous warehouse worker
"Why debate someone you fundamentally don't trust?" - Dario Amodei
"Seek wisdom, not knowledge. Knowledge is of the past; wisdom is of the future." -- Native American proverb
"Linux makes everything difficult." -- Lyceus Anubite