Autocomplete performance for large database

  • Profile Image
    Andy
    Asked 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

  • Profile Image
    abajan
    Answered 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
    markashton
    Answered 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