Performance issue

[amuda78]

Hi,

I get an error " The script you're running may cause your computer to become unresponsive...." both in FF3 and IE7 when try to load about 1000 records in the listgrid. I am using XML as the ds. What's the cause of the problem? Will it be eliminated if I use SQL as the ds?

Thanks

Dan

[nickc]

This sounds to me like you're trying to load to much data at once, have you thought about paging the listgrid?

You can then load a limited number of records at a time, as the user scrolls down the list more records can be loaded.

Have a search on the forums for listgrid paging, you should find some useful code to get you started.

[amuda78]

I've tried using RestDataSource but still getting the same error...if it can be solved using SQL ds I don't mind to purchase the pro edition.

[nickc]

Are you creating a resultset?

Are you setting dataPageSize, drawAheadRatio?

Have you set up your XML to be returned as paged results?

Does it return startRow, totalRows and endRow?

[amuda78]

yes, it does shows startRow, totalRows and endRow and the XML returned as paged results. I limit each result to show only 20 records but when I scroll down quickly this error will occur.

[nickc]

It sounds like your grid is performing a large number of requests to your server and the browser can't cope.

How many records can be seen on screen at any one time without scrolling?

If it's 20 or less you should increase the dataPageSize.

I normally set the dataPageSize to 75 and drawAheadRatio to 2 or 3.

Try increasing the numbers and see what happens.

[amuda78]

Ok will try that. BTW will SQL ds type helps in this case?

[Isomorphic]

Using the SmartClient Server in general is going to be the fastest available way to deliver data to the browser. Switching to SQL DataSource would probably correct this simply because you can see many samples that require no client or server code at all to manage data transfer, and don't exhibit this problem.

However to be fair, the XML protocol works well too (just not as well), and is capable of loading far more records than you are attempting to load without showing any performance issues.