Wednesday, 29 July 2009

SQLite is no more

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

0 comments:

Post a Comment