Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Guy Gilboa 3 posts 73 karma points
    May 31, 2018 @ 08:40
    Guy Gilboa
    0

    Forms GetRecords

    Hi All,

    I have some form with more than 5000 entries. I developed custom grid that display all the entries that exist. I use GetRecords method that doesn't expose pagination at all. My query takes more than a minute until I get the records. Maybe there is another API that I don't familiar with?

    Best Regards Guy

    Copy Link
  • Frans Lammers 57 posts 400 karma points c-trib
    May 31, 2018 @ 10:43
    Frans Lammers
    0

    Hallo Guy,

    We had a similar problem in accessing records from forms. We did not find another API, so we ended up doing it ourself.

    We added an index we needed to the UFRecords table and accessed the records directly using a new database connection. This gave us full control and the speed we needed.

    regards, Frans

    Copy Link
  • Guy Gilboa 3 posts 73 karma points
    May 31, 2018 @ 12:35
    Guy Gilboa
    0

    Hi,

    We did the same solution.

    We access the forms table directly.

    I hope someone will offer better solution.

    Regards

    Guy

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft