Clean AsyncOperationBase table

Hi,
Highly recommend to clean table AsyncOperationBase for performance issue.
http://support.microsoft.com/kb/968520

this script clean the table and improve Async operations.
thanks,
Rami Heleg.

Use Thread to improve performance.

Option to improve performance for callouts or just server side is to use thread

Here Is an example of using thread:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace thread {

class Program {
static void Main(string[] args) {
  System.Threading.ThreadPool.QueueUserWorkItem(f => {xxx();});
  }

  static void xxx(){
  int a = 8;
  }
 }
}



Enjoy,

Rami Heleg

Using CRM 3/4 with Internet Explorer 6

Hi,
adding JS + AJAX CRM 3,4 using Internet explorer 6 may cause edit.aspx to freeze when loading.

Reason:
When page is loading explorer 6 behavior is a different from explorer 7,8.

If you add some code ( JS + ajax) when page is loading .. before client finish with all methods the lookup fields on the screen start to throw error (on focus event). but in explorer 7 only after all code is finished then lookup start with focus.

You can change the htc, JS files in many places but this is not a good solution.

solution:

upgrading to Internet explorer 7,8 solve this issue.

thanks Rami,

CRM performance is very slow

I work with CRM ¾ and all the system works very slowly

Loading pages is very slow, and all the system looks busy.

One of the options is Antivirus.

When you work with CRM and open some pages for instance Edit.aspx not only the edit.aspx is downloaded from server many JavaScript + CSS + other linked pages is downloaded too

If antivirus is working check if Antivirus is scanning all the scripts and pages when you request page from CRM.

if yes... change the Antivirus to prevent of scanning all CRM pages and the performance back to be perfect

I got this problem with Antivirus MCAfee.


workaround
http://support.microsoft.com/kb/924341

https://kc.mcafee.com/corporate/index?page=content&id=KB65382&actp=search&viewlocale=en_US&searchid=1278011200919

Thanks,
Rami Heleg.

Fetch or Retrieve?

Fetch or Retrieve?

The million dollars question what is better using fetch or RetrieveMultiple...

RetrieveMultiple faster than the Fetch method Retrieve doesn’t have to parse the query.

My tip:

Work direcly with CRM DB for Queries and update.

Important:
Use “nolock” for select command.
in this case database doesn’t lock the table
Use “rowlock” to update table lock only the specific record.

Example for select command:

Select firstname, lastname from contact with (nolock)

Example for update command:

Update incidentextensionbase WITH(rowlock) set new_firstname = ‘aaa’ where incidentid = ‘{fdkjdf98438e9w8euew987}

Enjoy,
Rami Heleg

Shrink Javascript file

to improve performance one of the options is to shrink Javascript file.
link to site that help you to shrink the file and save 30 % from file size
http://www.creativyst.com/Prod/3/.

Recommended to do it before moving to production

Thanks,
Rami Heleg