MySQL sync

[Derek Atkins]

Marcus,

Marcus Wolschon <Marcus at Wolschon.biz> writes:

> There must be a way without violating 1st normal form and storing
> everything twice.
> Maybe an "updated"-timstamp or something may help.

Maybe...  I was thinking about ways to avoid using timestamps per se,
because the current time can vary machine-to-machine.  I was also trying
to avoid queries like:

  select * from * where last-updated > 20090807100412

[ yes, I know this isn't valid sql ]

> (Also I`m concerned that still loading all transactions from the db
> into ram will work
>  out after a few years of bookkeeping. You cannot split a database by
> year as you can
>  an xml-file.

Why can't you?

But yes, eventually we will need to solve this problem.

>  I'm thinking about maybe 100 splits and 40 transactions as well as 10
> currency-quotes
>  every day for 10 years as a sensible testcase for scalability.)

Sounds like a reasonable test case.

> Marcus

-derek

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available