Dev help needed: improving DB throughput

Anything to do with the Pale Moon Sync service.
User avatar
Moonchild
Pale Moon guru
Pale Moon guru
Posts: 35651
Joined: 2011-08-28, 17:27
Location: Motala, SE

Dev help needed: improving DB throughput

Unread 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
"Sometimes, the best way to get what you want is to be a good person." -- Louis Rossmann
"Seek wisdom, not knowledge. Knowledge is of the past; wisdom is of the future." -- Native American proverb
"Linux makes everything difficult." -- Lyceus Anubite