Coolite: THE SPEED OF LIGHT!

[reinout.mechant@imprss.be]

The biggest concern most fellow developers (not coolite) and customers have on web development and especially ExtJS and Coolite is the speed. Though most samples seem quick and responsive, samples with more data are most of the time slow.

Correct is my answer, if implemented WRONG!

If someone again tells you ExtJS (and Coolite in that matter) is slow, now you can tell them YOU have seen an example where more than 1 MILLION records could be managed by coolite, AND even without a mouse!

On the link below you can find my demo setup with a stress test of 1,104,075 records (I know, it is only one field, but yet...).

In this demo, you even practically don't need the mouse anymore: editing of a row is done by:
- select a row and click on the edit button on top
- double click on a row
- right click on a row and select edit
- press ENTER on the keyboard on the selected record

To create a new record:
- click on the new button on top
- press 'N' on your keyboard

To save the record in the Edit dialog: Just press ENTER

To duplicate a record:
- select a row and click on the duplicate button on top
- right click on a row and select duplicate
- press 'D' on your keyboard

To delete a record:
- select a row and click on the delete button on top
- right click on a row and select delete
- press DELETE on your keyboard

To move from page to page:
- click on the left and right buttons on the bottom (pagingtoolbar)
- click the left or right arrow on your keyboard

When a record is added or one is changed, the record will automatically be selected again (and brought to the page where it needs to come due to sorting)

Voila, that's it folks! Have fun with the demo:

http://web.scriberit.com/Application.aspx

In the accordion select Settings: then open Settings > Global Settings > Technologies

And there it is!

Thanks again to the folks of Coolite!

Kind regards,

Reno

[reinout.mechant@imprss.be]

All,

Please test it out, let me know what you think, what the speed is like, if there are still bugs, etc.

Keep me informed,

Reno

[reinout.mechant@imprss.be]

All,

In the sample I've added a second Technologies (100k) with 100000 rows to compare the speed with one million.
Both are using the same technique, only the number of rows is different.

Kind regards,
Reno

[mwatt]

Thanks Reno, that's great!

I'd be interested in seeing the code you used!

Have you thought about doing a one to many test?

Cheers,

Matt

[reinout.mechant@imprss.be]

A one-to-many is the next in my list, first the search and adding some more fields into the bucket.

The code is actually simple, I work almost only with AjaxMethods.
I don't have a datasource in the aspx, I use DataSourceProxy.

The highload is done via paging in the stored procedure using CTE.

Maybe later on I'll put some code online.

[danielg]

Thanks for the example.

Would be useful to see source code, to see how you have implemented this.

[reinout.mechant@imprss.be]

You can find already some pieces of code here:
http://forums.ext.net/showthread.php...0146-16-1.aspx