Move areweslimyet.com to PostgreSQL

NEW
Unassigned

Status

defect
6 years ago
6 years ago

People

(Reporter: johns, Unassigned)

Tracking

Firefox Tracking Flags

(Not tracked)

Details

()

[ Filing this in bugzilla since its relevant to other B2G awsy work tracked here. ]

AWSY's backend uses sqlite to store data. When I wrote it, we were getting maybe hundreds of lines per build, run once per m-c push. Now we run two, soon to be three, tests on every m-i push and the return tens of thousands of lines. The AWSY tester is soon going to be bottlenecked on inserting results into the DB.

We don't run any complicated queries, so changing to PgSQL should just be a matter of setting it up and changing the connect-to-db scripts. The partition-sqlite-by-month maintenance script would also need to be changed.
You need to log in before you can comment on or make changes to this bug.