In order to make life a little easier on all of us,
Ive written a script to synchronize databases
between orange and clients. In order to make the
script run somewhat efficient, I added 15 triggers
(insert, update and delete for each of the 5 large
tables) to the Universal database on orange. The
changes are stored in a new database univ_changes.
When those 5 tables are changed locally, only the
changes will be uploaded to clients. This means
that you cann...
10:30 < procyon> so 15 triggers to speed up an upload that isnt that large, and slowed all inserts down signifigantly
10:31 < procyon> doubled and tripled the time it takes us to do our bulk inserts
10:34 < procyon> its not funny but its a sign of his engineeriness
10:34 < procyon> AND NOW HES IN MY CODE
No comments:
Post a Comment