Thursday, April 20, 2006

Yesterday's Learnings

  1. Couldn't find any good articles on Soft-Delete optimization that lists approaches for referential integrity, improving fetch operations etc.
  2. No good articles on Role, Permissions, Groups, Module type security on BO Level, DB Level and UI Level
  3. Explored DotLucene - Very good search engine - easy to use
  4. Created PDF plug-in for DotLucene - as per guidelines - really good
  5. No good articles on Custom Paging with .NET and SQL Server 2000 - Article on 4GuysFromRolla is more or less impractical - most of the times, we don't fetch indexed records based on primary key only
  6. Worked on initial portions of an article planned to be released on Code Project for SQL Server 2000 paging
  7. Worked on some performance testing on composite Lookup tables - found that performance loss was negligible

No comments: