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