ConfiForm Data

[Gian Franco Morassutti]

Hi all,

I created a form using ConfiFroms fields and I am displaying the records using the ConfiForms Table View. After 1500 records submitted, the page that displays these records is becoming slower and slower. 

Is there a way to archive some of the data or records that are old? I don't want to clean it up completely, but just extract the data that is 1 year old for example.

[Alex Medved _ConfiForms_]

Consider setting up the pagination or setting the limits on the data

It is expected to see rendering taking more time the more records you add and want to show at once (large html produced, more records to render)

[Gian Franco Morassutti]

Hi Alex, thanks for your reply.  How do I set up a pagination or a limit to the data?

[Alex Medved _ConfiForms_]

(almost) Every view macro in ConfiForms has this parameter, which allows you to set a pagination

[Gian Franco Morassutti]

Thanks Alex, I applied the pagination and the page is so much faster now, but my confiform table view is not displaying any records now. I put 25 on paginate and it doesn't show me anything

[Gian Franco Morassutti]

now I put 500 and to see the latest records, which is what I want to see first, I need to go to the their page (I have 1700 records). Do you know how I can see the latest records on the first page? I tried using default sorting through the table filter macro because I have a confirm form definition with auto number (for the ticker numbers), but that didn't work either

[Alex Medved _ConfiForms_]

Sounds like nothing is working for you for some reason...

To sort the records in a reverse order I would do the following