Performance problem in QuickTableFilterField

This forum is used by users to request and discuss new product features. Please do not use this forum for technical support including bug reports.

Moderator: JIDE Support

Forum rules
Product suggestions only. Please do not use this forum for technical support including bug reports.

Performance problem in QuickTableFilterField

Postby Nachiyappan » Tue Dec 08, 2009 3:29 am

Hi

I am doing searching using QuickTableFilterField in a table, which contains 20,000 rows and 100+ columns.

The performance is very slow. Is there any provision to improve its performance.

Thanks & Regards
Nachiyappan
 
Posts: 32
Joined: Tue Oct 06, 2009 9:10 pm

Re: Performance problem in QuickTableFilterField

Postby JIDE Support » Tue Dec 08, 2009 8:28 am

Is it possible that you use QuickTableFilterField#setSearchingColumnIndices() to limit the search to several columns? The reason is that, we will have to search every cell to decide if the rows should be filtered or not. Hence, one character input will cost 20,000*100=2,000,000 compare, which is expensive.

Thanks,
JIDE Software Technical Support Team
JIDE Support
Site Admin
 
Posts: 37219
Joined: Sun Sep 14, 2003 10:49 am

Re: Performance problem in QuickTableFilterField

Postby Nachiyappan » Tue Dec 08, 2009 8:42 pm

yes.. exactly the same.

But I need to search all the columns in the rows.

Is there any posiblity to override the search operation done in each key operation and to be done in enter key action.

Thanks in advance
Nachiyappan
 
Posts: 32
Joined: Tue Oct 06, 2009 9:10 pm

Re: Performance problem in QuickTableFilterField

Postby JIDE Support » Tue Dec 08, 2009 9:27 pm

Please try invoke QuickTableFilterField#setSearchingDelay(-1) to do search only on enter key.

Thanks,
JIDE Software Technical Support Team
JIDE Support
Site Admin
 
Posts: 37219
Joined: Sun Sep 14, 2003 10:49 am

Re: Performance problem in QuickTableFilterField

Postby Nachiyappan » Tue Dec 08, 2009 9:49 pm

Thank you..

Filter is working for enterkey event. But if I clear the field, that time too I need to give enter key to clear the filter. I dont want that...

If the field get cleared, the filter also have to remove.

Please give ur valuable suggestions.
Nachiyappan
 
Posts: 32
Joined: Tue Oct 06, 2009 9:10 pm

Re: Performance problem in QuickTableFilterField

Postby JIDE Support » Tue Dec 08, 2009 10:49 pm

Thanks for suggestion. Will fix it in 2.8.2.

Thanks,
JIDE Software Technical Support Team
JIDE Support
Site Admin
 
Posts: 37219
Joined: Sun Sep 14, 2003 10:49 am

Re: Performance problem in QuickTableFilterField

Postby JIDE Support » Wed Dec 23, 2009 8:58 am

Just so you know, this is fixed in 2.8.2.

Thanks,
JIDE Software Technical Support Team
JIDE Support
Site Admin
 
Posts: 37219
Joined: Sun Sep 14, 2003 10:49 am


Return to Product Suggestions

Who is online

Users browsing this forum: No registered users and 14 guests

cron