It looks like SQLite really can't hack it. I've moved the two G2 synchronisation processes g2_receive and g2_poll over to Postgres, and the improvement is staggering.
A database sync which was taking anything up to 2 hours to complete now finishes in less than 7 minutes !
There is SQL logic in dstar_g2, the main program, which needs modifying to use Postgres rather than SQLite, and that will take a few more days, but that should be all.
David
Subscribe to:
Post Comments (Atom)

0 comments:
Post a Comment