August 8, 2006

The Value of Data Archiving

Table(s) holding every day transaction data can grow huge in size over period of time. This not only slows down applications, it also causes database contention leading to maintainence nightmare.A simple table design modification can avoid lots of misery in your production environment. Instead of designing a single table holding

Folder Sharing in Windows

Have you ever needed to share many folders simultaneously? Windows provides an executable to do just that. It’s called the “Share Creation Wizard.” Call this wizard by typing SHRPUBW in the command prompt. Enter the folder path (or browse), the share name, the Share Description, Set Permissions, and then just

Forward Declaration of Classes Within Namespaces

Forward declaration is a handy mechanism for reducing the number of files you include in your headers. It is especially useful if your header file needs to be used by other classes/files. However, suppose you try to forward declare classes within a given namespace: class A::B::CClassName; You’ll probably encounter the

Activate Your Word Documents with VSTO

he word processor was invented to simplify the preparation of words to be printed on paper. It offered font management, layout management, and the ability to type words onto a soft screen, changing, formatting, and laying them out as you pleased before committing them to a hard-paper copy by printing

Batch Processing in Hibernate

Suppose you need to insert 200,000 records into a database in Hibernate. You’ll need to adjust the following settings: //set the JDBC batch size (it is fine somewhere between 20-50)hibernate.jdbc.batch_size 30//disable second-lavel cachehibernate.cache.use_second_level_cache false//and now do your job like thisSession S=SF.openSession(); //SF = SessionFactory objectTransaction T=S.beginTransaction(); for (int i=0;i