TYPE_AHEAD freezes in Web Client

[sergei.sheinin]

We have a type_ahead field whose values are retrieved from a database table:

Code: Select all

   var qry = "SELECT srch_text FROM search_texts // LIMIT 100"
   var dataset = databaseManager.getDataSetByQuery(globals.db, qry, null, -1)
   application.setValueListItems('searchTexts', dataset)


The table retrieves approx 40.000 rows. It works in Smart Client but when running in Web Client it freezes the browser with "loading..." message in top right corner. Adding LIMIT <small number> resolves the problem but obviously doesn't fetch all records. I changed increased "-Xmx1024m" to 1gb per a suggestion but it didn't fix the problem.

What is the limit of rows with which TYPE_AHEAD can work? Any workarounds?

[sergei.sheinin]

bump.


Please shed some light on up to how many records can Servoy type_ahead valuelist support?

[lwjwillemsen]

Hi Sergei,

Use a valuelist by global method in which you can control how many records are retrieved in the different
data entry situations (look into : realValue and displayValue). You don't need 40.000 rows in one list I suppose.

Regards,

[ROCLASI]

Hi Sergei,

This value list you want to use on the same column you are doing that query on ?
If so then you don't even have to create a value list other then setting the display type to TYPE_AHEAD.

If the field is not the same as your value list data then you could use a value list based on a global method (see valuelist properties window). This global method will then use SQL to dynamically fill the value list based on the typed information.
For a type ahead it shouldn't matter how much data there is in a table, it will only show the first 400 matching records according to the typed data.