Vivek Sharma

As the Web grows, a great deal of effort is being made toward writing applications in Java that interact with databases. Fortunately, JDBC provides an easy, database-vendor-independent way of writing such applications. While this approach works for a number of applications, there are limitations. For instance, if the application requires execution of a large number of SQL statements, efficiency becomes an issue since round-trips from the application to the database are costly. Also, since these statements aren't precompiled, the database system spends more time executing them than it would have if they were compiled and residing in the database. This is where PL/SQL comes in. It's a database language that enhances SQL by providing structure to SQL programs. It's rich with elements like control structures that we're used to seeing in such languages as C and Java. Thus ... (more)

Implementing a Lightweight Web Server for Resource Pooling and Scalability

On the Web it's about three things – speed, reliability and scalability. Does your Web site respond quickly? Does your Web site always respond quickly? Does your Web site always respond quickly when it's being used by tens or hundreds of thousands of users? Hardware is part of the answer, but software may arguably be more of the answer. Poor use of limited resources can affect performance as much, or more, as too little hardware. Over time your Web system may have become a combination of everything from static files to database applications, from CGI to servlets, from C to Perl ... (more)