loadrecords

Classic Servoy
1

which is faster?

loadrecords(ds) or loadrecords(sql_query, parameters)?
NOTE: userid is not the primary key, i have 150+ tables

	var tableNamesArray = databaseManager.getTableNames(globals.DB_SERVER_NAME)
	
	for (var indexRow = 0; indexRow < tableNamesArray.length; indexRow++) {		
		var tableFoundSet = databaseManager.getFoundSet(globals.DB_SERVER_NAME, tableNamesArray[indexRow])
		var table = databaseManager.getTable(globals.DB_SERVER_NAME, tableNamesArray[indexRow])		
		var idPrimaryKey = table.getRowIdentifierColumnNames()[0]
		var sql_query = "SELECT " +idPrimaryKey+ " FROM "+tableNamesArray[indexRow]+" WHERE userid=?"
		tableFoundSet.loadRecords(sql_query,[userid])
	}
2

loadRecords(query) is faster. When you use loadRecords(dataset) Servoy first fills the dataset and then fires another query to fill the foundset (select pk from table where pk in (dataset.pks)).