CHROMIUM

Welcome to CHROMIUM's very own blog!

August, 2012

IP Spoofing in LoadRunner Controller

Sometimes, your application works based on client IP. For example a public survey will require unique IP – it will deny multiple requests from single client IP. How would you load test such an application with 1000 Virtual Users in LoadRunner? IP Spoofing caters such situations. It sends requests to application from various client IPs […]

Database Performance Tip # 9

Do not use “select *…” or “insert into dbo.Table select…” (without explicit column list). Explicit column lists reduce disk I/O (no need to read system tables to identify columns), and are more maintainable when columns are added or re-positioned If a cursor is unavoidable, use a simple WHILE loop instead, to loop through the table, […]

Who Moved My Cheese?

Who Moved My Cheese? This is a summary of a very interesting story titled ‘Who Moved My Cheese’ by Spencer Johnson. This book is a simple parable that tells an amusing story of 4 characters who live in a maze and look for cheese to nourish them and make them happy. They represent the way […]

Select Composite key colums from same table in VIEWs

While creating views keep it mind that columns of composite key should be select from a same table otherwise views will perform very slow. Recently while doing WFS GAC optimization we found that the root cause of slow problem was a view in which a composite key columns was selected from different tables. After updating […]

Ensure fields index exist when Joining

The query should be carefully written and getting sure that on joining fields index must exist otherwise serious performance issue can raise as data volume will increase. The recent example of such case is found in MBFSJ. The dayend was executing in 3 hours and after monitoring the process below query found that was consuming […]

Checklist – The Last Ten Nights and Days of Ramadan…

In this blessed month of Ramadan, we have now come to the grand finale – the last ten days of Ramadan that are even more blessed than the rest of Ramadan. In it is a night that Quran tells us is better than 1000 months (yes, months – not days).   The Messenger of Allah (peace and blessings of […]

Optimise database deployement

Regarding NFS data storage architecture following points are important to get maximum system performance. Database server must be recommended with multiple physical hard disks or SAN/NAS with RAID or multiple logical units. NFS data files should be deployed on multiple disks as much as possible. Index and Data Files should be on separate disks. Database […]

Multi-tasking: Time Saver or Time Waster?

All too often, multitasking is promoted as an efficient way to meet the complex demands of our modern society and accomplish more in the same amount of time.  Have you ever attempted to work on a document, however, while cruising the Internet or talking on the phone? You don’t accomplish much, and time mysteriously disappears. […]