Hi, Load about 25k of records in a table called "articles".
To do the dynamic search of the information, I made a select to the table using the "like" function. Perform a test by entering the word "salsa". For each letter the routine goes to the BD and brings "n" number of records. For example: When registering the "s" character, 23k registers come, when I type the "a" they come 15k registers ..... My intention is to type the word "salsa" but the results can take up to 3 minutes. Is there any way to request the information to the BD when you already complete the word "salsa" and not for each character? Thanks -- You received this message because you are subscribed to the Google Groups "CodenameOne Discussions" group. To unsubscribe from this group and stop receiving emails from it, send an email to codenameone-discussions+unsubscr...@googlegroups.com. Visit this group at https://groups.google.com/group/codenameone-discussions. To view this discussion on the web visit https://groups.google.com/d/msgid/codenameone-discussions/1915741d-7542-420e-a6fd-8c23a986913a%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
