Jump to content

dbgrid LiveSearchGridPanel


erdal
 Share

Recommended Posts

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
 
post-1298-0-85921500-1407850196_thumb.png
 
 
Regards. 

 

 

Link to comment
Share on other sites

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
Link to comment
Share on other sites

  • Administrators

 

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?

Link to comment
Share on other sites

  • 1 year later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...