amittripathi2k2
Member
I have a form > FIR system with following fields.
FIR No.
FIR Date
District
Police Station
Complainant Name
Address
Incident Date
Section of Law
Document .PDF
Unique Code No.
User
Accused
SAVE
1. Where District and Police Station are cascading dropdown from another table.
District | Police Station
Arariya | Tarabari PS
Arariya | Araria PS
Arariya | Bausi PS
Arariya | Bhargama PS
Arariya | Chakkarbanda PS
Arwal | Arwal PS
Arwal | Banshi PS
Arwal | Kaler PS
Arwal | Karpi PS
Arwal | Kinjar PS
.... | ....
2. Accused is a repeat group > online_fir_21_repeat___Accused
3. Display mode is Merge rows and reduce data in Data > Joins
The form has entry of only 47000 data and repeat group has 150000 data. As understood from the Fabrik guide, form should be able to take millions of entry, but with only 47000 data the table has become painstakingly slow.
Please advise if how can I speed up the form.
FIR No.
FIR Date
District
Police Station
Complainant Name
Address
Incident Date
Section of Law
Document .PDF
Unique Code No.
User
Accused
SAVE
1. Where District and Police Station are cascading dropdown from another table.
District | Police Station
Arariya | Tarabari PS
Arariya | Araria PS
Arariya | Bausi PS
Arariya | Bhargama PS
Arariya | Chakkarbanda PS
Arwal | Arwal PS
Arwal | Banshi PS
Arwal | Kaler PS
Arwal | Karpi PS
Arwal | Kinjar PS
.... | ....
2. Accused is a repeat group > online_fir_21_repeat___Accused
3. Display mode is Merge rows and reduce data in Data > Joins
The form has entry of only 47000 data and repeat group has 150000 data. As understood from the Fabrik guide, form should be able to take millions of entry, but with only 47000 data the table has become painstakingly slow.
Please advise if how can I speed up the form.