TYPE_AHEAD freezes in Web Client

Classic Servoy
1

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

	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 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?
2

bump.

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

3

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,

4

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.