Friday, December 29, 2006

Scaling Data tier strategies

Kaushik pointed me to an excellent presentation of the eBay Architecture. The intriguing aspect has been scaling the Data tier and some of the interesting strategies suggested are a) No business logic in the DB, quite agreed but the strategy says not to use stored procedures, very interesting and recommends usage of extensive Prepared Statements with bind variables b) Auto commit for vast majority of DB writes.

It is PDF with lot of insights. Read it!

No comments: