performance of filter criteria

[eugenbesel]

hello all,

I took a look at examples on live demo page.

http://livedemo.exadel.com/richfaces-demo/richfaces/extendedDataTable.jsf?tab=usage&cid=2829489

and

http://livedemo.exadel.com/richfaces-demo/richfaces/filteringFeature.jsf?c=filtering&tab=ex-usage

by extendedDataTable when I enter more then one letter into filter field, then the table is rerendered for each letter.

for example I enter "con", then the table is rerendered for 'c' then 'co' then 'con'. Also three time. If I have a big table with more then 5000 entries I think it will be very slow.

by DataTable when I enter "con", the table is rerendered only one time.

In this case the filtering is faster as with extendedDataTable.

I took als a look on event in Code. In both case it is event="onkeyup"

what is the difference between these two DataTables?????

the same behavior is for sorting.

the sorting of extendedDataTable takes more time then the sorting of DataTable.

can I do anything that extendedDataTable works faster??

thank you

wbr

Eugen

[elf]

try to use

<a4j:queue requestDelay="#{queueBean.requestDelay}"

http://livedemo.exadel.com/richfaces-demo/richfaces/queue.jsf?tab=queueSettings&cid=2869181

It helps me with filter issue

[eugenbesel]

hello Serhij,

thank you for advice.

It works.

[eiselejosef]

Hi All,

changing the requestDelay helps really. Thanx for that tipp.

Now I can type in my filter-condition without getting my text overwritten. But after the set requestDelay is over, the filtering is done character by character. So the table is quite often rerendered and that takes in total a long time.

Any suggestions?

Kind regards

Josef

[nbelaevski]

Try increasing request delay.

[eiselejosef]

Hi Nick,

thanx for your answer.

I tried values up to

     <a4j:queue requestDelay="10000"/>

but that doesn't change the problem.

I understand this attribute

     requestDelay - Attribute defines the time (in ms) the request will be waiting in the queue before it is ready to be sent.

that the requests are queued and after that time in ms all requests are sent. What I want is not n Requests for n characters of my filter-criteria. I want 1 request for my whole filter-criteria.

cu Josef

[nbelaevski]

Josef,

While requests are waiting in queue, they are combined into a single request if came from the same component. If I set requestDelay=300 for queue, then, while I'm typing, requests are not sent. After I stopped typing and request delay passes, single request is sent. If I start typing again, they will be combined into a single one and sent after request delay triggered by me stopped typing.

Is this scenario satisfiable for your requirements? Looking at "10000" delay it is 10 seconds delay - very huge. So I want to confirm: does this work as I've described or not?

[eiselejosef]

Hi Nick,

10000ms was a test, at the moment I use 800ms.

You are right up to a certain point. If I type in 3 characters as filter criteria the table isn't rendered the moment I'm typing. But after I stopped typing and a certain time (depending on value of requestDelay) the table is rendered (I didn't check whether there is a request sent to the server, but I can see the table filtering/rendering) character by character. In my case 3 times. Also if I delete the filter criteria.

For me this:

"After I stopped typing and request delay passes, single request is sent."

is not working. My structure at the moment is:

<rich:extendedDataTable ...">
        <a4j:support event="onselectionchange" reRender=".../>
        <a4j:queue requestDelay="800"/>
       
        <rich:column ..../>
        </rich:column>

</rich:extendedDataTable>

cu Josef

[ilya_shaikovsky]

move queue out of the table(just made it form child) and retry. illustration of Nick's explanation here:http://livedemo.exadel.com/richfaces-demo/richfaces/queue.jsf?tab=queueSettings&cid=10576962

[eiselejosef]

perfect, thanx :-)

Now all other AJAX-requests on the page are also queued, but this is o.k.

cu Josef

PS: Any answers on http://community.jboss.org/thread/149260 ?