SQL Server Performance Improvement Best Practices: ISNULL

ISNULL(). As you know this function is used to set value in case of NULL value found. Do you ever think that sometime this function impact performance? Yes, It impacts if you use in left hand site in WHERE clause. Here we put some statistics to measure.
Read More

 Bharat Patel     Jun, 05 2017

Troubleshooting Git Fatal Error: Failed to Read Object Xxx: Invalid Argument

Recently, I was facing the git fatal error when I pull new changes from remote repository, This is probably due to my computer was shutdown due to power cut, I had faced similar error previously and I'll explain that we well in my next post
Read More

 Vikas Patel     Jun, 05 2017

Statement Cancelled Due to Timeout or Client Request

I would like to share one of the cfsqltype issue that I face with Lucee CFML Engine. Initially we use Railo as CFML Engine and recently we change it with Lucee and facing an MySQL query timeout issue. when I try to run that query into MySQL Workbench it works fine and quickly but the same query raises an error (Statement cancelled due to timeout or client request) on Lucee.
Read More

 Mahavir Dhruv     Jun, 05 2017

MSSQL Table Get Locked and Query Keep Running and Unlock It

Today, we were tuning our long running sql queries and found that the longest query was keep running. We know that sql does some locking so we thought that the table would have acquired a lock but it was not release by the process.
Read More

 Vikas Patel     Jun, 05 2017

How to Write Test Case for Handler Using Testbox

A month ago I have posted the testbox example for unit testing and promise to post a example of handler testcase using testbox. I found significant difference in the handler test case. Like it's bit difficult to use and access mock of any model, Like we mock the model in unit testing. Also handler testing interect with the database.  
Read More

 Parixit Jani     Jun, 05 2017

Task Scheduler Was Not Working Social Engine Video Upload Module - Solved

Recently I started reviewing SocialEngine (Short desc: create your own social networking site), and I face some issue with video uploading process.I am using SocialEngine 4.1.7. By default, user can only embed Video from YouTube and Vemio. But if you want to upload the Video file, you need to allow it by enabling settings from the Administrative area.
Read More

 Vikas     Jun, 02 2017

Saving with EC2 Reserved Instance: AWS

Recently working with client to move ColdFusion project to AWS which has seasonal traffic. Key points are saving cost and easily upgrade/degrade server whenever needed. Initially start with On-Demand instance to make sure everything working fine before we permanently move to Cloud. As to save we have option to create reservered instance instead of ondemand. Recently Amazon introduce three type of reserved instance. Light Utilization Medium Utilization Heavy Utilization ...
Read More

 Admin User     Jun, 02 2017

One More Good Reason to Define Local Variables in Function Instead of Variables Scope

I used to create application variables for my cfc object which usually called many times from my coldfusion pages. This will help you to save execution time required to create object everytime. But it is highly recommand that you use local scope for all function local variables or there will be change your variables scope value may overwrite by other function. As a best practice it is always advisable to use local scope for function but by nature of programmer we always avoid to use it specially
Read More

 Pritesh     Jun, 02 2017

Strange ColdFusion Issue, JRUN Eating Up to 50% of CPU

For one of our project we recently move to Amazon EC2 to make system easily scalable. This is kind of seasonal website which has high traffic during September and October and rest of the year traffic reduced to 70% with compare to October month. I think Amazon's usage based model is perfect for this client as he doesn't need to pay much on his off season also we can easily scale and add new instances during peak season and cover cost that we saved during off season.
Read More

 Admin User     Jun, 02 2017

  • Showing 31 to 40 of 225