Jump to content

dbgrid LiveSearchGridPanel


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 post
Share on other sites
  • Administrators

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.

Link to post
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 post
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 post
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.

×
×
  • Create New...