By Default Sitecore cache application data. That means if we have 2 developers sharing the same DB, and 1 developer made an update to Sitecore DB, the other developer will not see the DB changes unless he/she restart his/her application pool.
This generally does not cause much problem, because when we developing, we often build our solution which in turn restarting the application pool at the back.
Yes, this is a challenge.
ReplyDeleteYou do not need to restart the application pool, - you can clear chace usign teh cache clearing adminstrative tool: http://localhost/sitecore/admin/cache.aspx
Have a look at this great article explaing multiple developers on same database:
http://blog.ariesnet.com/2010/02/24/HowToUpdateYourSitecoreDevelopmentEnvironmentWithSQLReplication.aspx
Also, - Sitecore is soon to release a version of Sitecore, code name Twin Peaks, which will clear cache incrementally, - automatically.
This will solve this challenge.