3 ms·
A bit more than that: "Group, convert and collapse your DB commands!" insert 1, insert 2, insert 3 == insert [1,2,3] insert 1, delete 1 == [no-op] As the
by rkalla 15y ago
A bit more than that: "Group, convert and collapse your DB commands!"
insert 1, insert 2, insert 3 == insert [1,2,3]
insert 1, delete 1 == [no-op]
As the author pointed out you need to know a bit more about your domain to make this really efficient, for example:
insert user1.dob, delete user2.dob = [2 discrete ops]
while
update user1.dob, delete user1.dob = [1 op - delete user1.dob]
Cool idea; lots of opportunities for enhancement. The one thing you would have to look out for is effectively re-implementing a query optimizer inside of your application code and eating up too much CPU time on a busy system prepping calls.
If you are not I/O bound, then this strategy isn't going to help you that much. If you are I/O bound, it is a great way to help get yourself out of that hole.
- deleted 15y ago[deleted]