What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Autocomplete performance for large database

    Asked by Andy on June 13, 2012 at 09:32 PM

    I'm just amazed with jotform performace and user interface. I can say this is the best system I've ever seen. Thanks for doing this wonderful alternative to make life a lot easier :)

    I'm not gonna use any storage but even so I'll suscribe myself in a plan to support jotform :)

    Just have one question. I'd like to use autocomplete fields for names, medication, etc.. I have a large database of names for instance (over 10,000 entries) I was wondering if the form will be affected in loading time and general performance by using this large amount of data. I'll need to place the same field several times in the same form (using conditionals) so I'm not sure if this amount of data will crash the form (and webpage).

    Is there any (suggested) limit of entries for autocomplete fields?

    Again thanks a million for making jotform a reality..

    Cheers

     

    Andy

    JotForm
  • Profile Image
    JotForm Support

    Answered by abajan on June 13, 2012 at 10:03 PM

    Andy

    Thanks so much for your glowing comments on our product and your eagerness to contribute to our coffers! :)

    As to the autocomplete functionality, it would increase the load time of the form but I can't say by how much. I suppose the best way to find out would be to create a form strictly for testing purposes. Services like LoadImpact can be used to compare results of a form with empty autocomplete fields versus when the said fields are filled.  (Just out of curiosity, I might run some tests on some of my own forms which have autocomplete fields.)


    Wayne

  • Profile Image

    Answered by markashton on October 01, 2014 at 06:18 AM

    Hi,

    I know this is an old thread but my question is identical and Abajan makes some relevent points that I would like to track.

    As it is an old thread I would like to check the thinking on this.

    I would like to put in 1500 names that 1500 respondents could write the first three letters of their first name and bingo ... done.

    Is there an issue with this many names using the Auto Complete Widget ... before I go down this route and find it can't work.

    Thanks Mark