• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: Rsform Pro is DEAD SLOW!

Rsform Pro is DEAD SLOW! 16 years 7 months ago #4846

  • rayge
  • rayge's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 8
When i click to view data:
My smallest data set for a particular form is
661
I have a total of
4816 in one and
3406 in another

Obviously the issue with the OLD rsform was there was no pagination.
IN this version it does but when i click to VIEW data it NEVER came up. I waited well over 5 minutes.

I thought point of pagination was to speed up the viewing time?
Whats the deal?
The administrator has disabled public write access.

Re:Rsform Pro is DEAD SLOW! 16 years 7 months ago #4850

  • rayge
  • rayge's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 8
Ok so HERES the deal. If anyone else has this issue about the admin list displaying slooowww.

I checked the table related to the submissions and... They are MISSING indexes!
IN phpmyadmin:

view structure of
jos_RSFORM_SUBMISSIONS
and add an index to FormId (not unique and NOT primary)
THEN

view structure of
jos_RSFORM_SUBMISSION_VALUES
and add an index to SubmissionId (not unique and NOT primary)
If you already have a lot of data it may take a while for it to do the indexing. I was importing from the old version of RSFORM so i just re installed then did the indexing befor i did any importing to save time.

Hope this helps someone. (including the developer)
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!