On Fri, Jan 3, 2014 at 1:02 AM, Colin Reese <[email protected]> wrote: > Good info. I'm not sure why it should choke on that. There are examples of > sqlite for huge implementations, but I'd probably journal a log long before > it got to that size.
If I remember correctly it didn't choke on the writing itself. It's just that I need to do efficient date range queries to build the charts and it got progressively slower as I had more data. Mysql itself has gotten slower as the data piles up and eventually I'll have to do some caching instead of relying on the database to be fast on its own. > I'm fine with only one writer, and besides the database only locks for a few > ms when that happens. > > I prefer the small, light, and fast on a modestly powered device like the > RPi, and it's an easy port to MySQL if I decide to go that route at some > point. Right, that's why I regret not using ActiveRecord on the last rewrite. I considered it and thought I was overengineering things but it would be nice to have that flexibility now. > Colin > > P.S. Many would take offense to saying sqlite is not a 'real' database. It's > just a different model. It all depends on what you need. :) right, but I guess you know what I meant ------------------------------------------------------------------------------ Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk _______________________________________________ Owfs-developers mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/owfs-developers
