Hi!

What is CDN you can read in http://en.wikipedia.org/wiki/Content_Delivery_Network
http://ajax.aspnetcdn.com/ajax…..4.4.min.js
http://ajax.aspnetcdn.com/ajax…..-ui.min.js

Then the clients from somewhere in the world which loads you pages will load the files probably more quickly. It can be also that they has a cached copy of the files already on his computers and the loading will be done from the local cache.

If you need jQuery, jQuery UI and jqGrid for some web sites from your internal web server (on intranet of your organization) the usage of CDNs from the Internet can be or not be a good idea depand from the usage of proxy server in your internal network.

On the other side you can load the same files from the Goodle CDN (see http://code.google.com/apis/libraries/devguide.html#jquery
https://ajax.googleapis.com/ajax/libs/jquery/1.4.4/jquery.min.js
http://ajax.microsoft.com/ajax…..4.4.min.js

in the order which I also use. I personaly can not compare the perforance of loading jQuery and jQuery UI from different points of the word and just use as the URLs which started with http://ajax.googleapis.com/ajax/libs/.

I have no idea how to place some additional JavaScript library on one from the CDNs. Probably a politic play a role here. If Tony be able to place jqGrid on one from CDNs I will imediately use it.

Best regards
Oleg

Hi wakelt,

the problem with full working examples is that the code will consist not only from the client jqGrid code, but from the server code written in one technology and assessing one type of database also with one technology. I personally not use PHP and MySQL. I use more Windows and Microsoft .NET technologies. If I find a Java code it will help me not really. Some code can be written very close to XML. If other need JSON the code must be also adapted.

If I use for example .NET on the server side I have many choices. The most important are: ASP.NET MVC, WFC service or ASMX web service. The access to the Microsoft SQL Server could be using LINQ to SQL, Entity Framework, with SqlDataAdapter or SqlCommand and SqlDataReader. You can implement ASP.NET MVC, WFC service as RESTful services or not. I can continue. What I want to say is there are too many design choices which you have to made. All there will follow to different server code in many possible languages.

It is a main reason why it is difficult to find the whole code example which you can use.

If you use .NET, C# and some from above listed technologies I could post you some links where you will find the corresponding working code.

Best regards
Oleg

Hello chillifire,

It seems to me that the reason of the problems which you has is the usage of the line

jQuery("#listSales").setGridParam({datatype:'local'});

or the lines

jQuery("#listSales").setGridParam({datatype:'local'});
var allData = jQuery("#listSales").getGridParam('data');

after the jQuery(“#listSales”).trigger(“reloadGrid”). The problem is that the loading of the JSON data from the server work

Yes! All which you ask for is possible. Look at the postData parameter and this

I don't recommend you to use datatype as function if it is not really required. In very old version of jqGrid (more as one year old) was less support for different options of ajax requests. Since at least more then one year you can use new options (see here

Hello dm,

the information that you use loadonce:true parameter is very important. In general you should send the data from the server in the sorted order. It you don't do this you can reload the grid, but because of usage of

Hello Klaus,

some questions stay opened for me

1. How you load information in jqGrid initially? The variable newTableSettings seems me a little strange and set more questions as

I suppose that without the code example of your JavaScript code, full HTML code with the list of all JavaScript files which you load, information about versions which you use (versions of jqGrid, jQuery, jQuery UI and so on) and the test data (in JSON or XML format) nobody are able to help you. Only after having this information one can give you some tips for the performance improvement.

Moreover I am sure that your real requirement is a little other. No person can really able to read 1000 rows of the multi-column contain at ones. No monitor can show the 1000 rows at once, so the scrolling of data will be done either by the web browser or by jqGrid itself. So the usage of at least client side data paging can be used without changing of your requirements. Moreover the usage of client side data filtering for example with respact of Toolbar Searching