Re:SQLite 3.8.0 Release with next-generation query planner
by eksith on Tuesday August 27, 2013 @04:48AM
(#6282252)
Yes. Yes there were. :)
We always limited transactions for UPDATES and INSERTs that involved more than one table.
It was quite the learning experience since you do have to think of different ways of working with data. You get to learn very quickly the difference between what like to store vs. what you actually need to store to get a particular functionality. But that turned to being a boon in the end because we got a much simpler forum as a result. Fewer bells and whistles meant users focused on actual discussion and not ancillary, shiny bits and bobs.
We always limited transactions for UPDATES and INSERTs that involved more than one table.
It was quite the learning experience since you do have to think of different ways of working with data. You get to learn very quickly the difference between what like to store vs. what you actually need to store to get a particular functionality. But that turned to being a boon in the end because we got a much simpler forum as a result. Fewer bells and whistles meant users focused on actual discussion and not ancillary, shiny bits and bobs.