Open Bug 977354 Opened 6 years ago Updated 6 years ago

Move areweslimyet.com to PostgreSQL

Categories

(Testing :: General, defect)

defect
Not set
normal

Tracking

(Not tracked)

People

(Reporter: johns, Unassigned)

References

()

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.