dbgrid LiveSearchGridPanel

[erdal]

http://dev.sencha.com/extjs/5.0.0/examples/grid/live-search-grid.html

 

how to use, my delphi application.

 

Pls help me.

[rullomare]

Hi erdal, 

 

I tried to create a LiveSearchGrid without much difficulty. 

 

If you want, I can post it, but I wish to inform you that there are major problems with performance if you use a lot of records. 

 

With up to 200 records of the query , the performace is acceptable. 

 

My opinion is that it is not usable in production. 

 

 

let me know. 

 

 

 

Ps. I used PageSize Extension for UniDBGrid posted from  Delphi Developer

 

      Unigui 0.09..   and delphii xe3 only

 

 

 

Regards. 

 

 

[Farshad Mohajeri]

there are major problems with performance if you use a lot of records.

 

With up to 200 records of the query , the performace is acceptable.

 

My opinion is that it is not usable in production.

 

Performance loss here is related to the Query itself not the uniDBGrid.

[rullomare]

Hi Mr. Farshad, 

 

 

The  unidbgrid is ok . 

 

 

then search is not performing if  the query produces more than 100-200 records. 

 

 

 

please see the code   LiveSearchGridPanel.js

 

For each character typed on the search field, the search is started ( done)   on each column , and rows. 

 

 

   

 

 

 

 

P.s  The query time (5000 records) is normal , ok.

 

     it is still my opinion that  LiveSearchGridPanel.js   is   only for demonstration  use .

 

I enjoyed it anyway .. 

 

 

 

Regards 

 

Salvatore Marullo

[erdal]

Fine thanks. Would you share with us the code.

[Farshad Mohajeri]

 

Hi Mr. Farshad, 

 

 

The  unidbgrid is ok . 

 

 

then search is not performing if  the query produces more than 100-200 records. 

 

 

 

please see the code   LiveSearchGridPanel.js

 

For each character typed on the search field, the search is started ( done)   on each column , and rows. 

 

 

   

 

 

 

 

P.s  The query time (5000 records) is normal , ok.

 

     it is still my opinion that  LiveSearchGridPanel.js   is   only for demonstration  use .

 

I enjoyed it anyway .. 

 

 

 

Regards 

 

Salvatore Marullo

 

 

Is it a client side search?

[rullomare]

Hi  Mr. Farshad, 

 

Yes !! 

 

Regards, 

 

Salvatore Marullo

[mmx110]

Hi rullomare!

Please make a sample for Forum and place here...

Regards