incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Simon Woodhead <simon.woodh...@simwood.com>
Subject Re: Map/reduce and transactions
Date Fri, 13 Aug 2010 17:33:42 GMT
>
> You could keep the summing in Couch as long as you have a balance-forward
> transaction to start the new month with some data, as Chris suggested.
>  Also, keep in mind that Couch can do this sum more efficiently than SQL
> because the reduce function to sum the view will store intermediate values
> in the index. Incremental updates are relatively cheap and you never have
> to
> compute the entire sum except the first time you insert your data.
>

Yeah that makes perfect sense, thanks.

Right now it is so laborious in MySQL as the index is invalidated with
constant reinserts so there is massive value in only computing the balance
incrementally. The same is true of other views on this data.

Thanks for your help all,
Simon

--
***** Email confidentiality notice *****

This message is private and confidential. If you have received this message in error, please
notify us and remove it from your system.


Simwood eSMS Limited is a limited company registered in England and Wales. Registered number:
03379831. Registered office: c/o HW Chartered Accountants, Keepers Lane, The Wergs, Wolverhampton,
WV6 8UA. Trading address: Falcon Drive, Cardiff Bay, Cardiff, CF10 4RU.


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message