Quick note to myself.. If you have a high volume transactional database and are looking to purge data from a table(s).. make sure you purge the data in small chunks. If you purge the data in larger chunks (rows), other processes trying to access the data on those tables have to go to the redo logs to access the data, since the purge job will put a lock on the table. This obviously adds latency to the queries.. So purge the data in smaller chunks (rows), forcing the database to flush the redo logs.
January 27, 2009
Why I added 5lbs of weight in 3 weeks…
Five Guys, a burger chain from the east coast opened their first franchise in Chicago… If you want some fresh juicy burgers and peanuts to eat while the burger is being made, this is the place to go to. I first tasted the Five Guys burger when I was in Washington DC, a couple of years ago, on work.. I thought how cool, it would be to open one in Chicago. Looks like some enterprising entrepreneur actually took my idle thought and opened one :-).. It is located at 2140 N. Clybourn Ave.
Coming to the title of this post.. Why did I add 5 lbs of weight? These three pictures should tell you why..
YUM
YUMMM
YUMMMMMY
OK.. That is my friend Rich.. but you get the idea :-)..