Dear all,
I'm trying to implement MetaModel as component to allows aggregation and
filtering on a Pojo object used in out project as data store.
My first integration does something like the following code snippet:
/SimpleTableDef dataStoreDef = new SimpleTableDef(uniqueTableName,
columnNames, columnTypes);//
//ArrayTableDataProvider dataStoreTableProvider = new
ArrayTableDataProvider(dataStoreDef, arrays);//
// DataContext dataContext = new PojoDataContext(DEFAULT_SCHEMA_NAME,
dataStoreTableProvider);//
//
//// Change table name to be concurrency-safe//
//String newSqlQuery = sqlQuery.replace(DEFAULT_TABLE_NAME,
uniqueTableName);//
//Query query = dataContext.parseQuery(newSqlQuery);//
//DataSet dataSet = dataContext.executeQuery(query);/
Basically, I extract the metadata (/uniqueTableName, columnNames,
columnTypes/) and data (/arrays/). The problem is the query execution
time, which seems to be soo long even for medium dataset (150.000 rows).
It takes *minutes *to process the query extracting the resulting
dataset. All the information are in-memory, so I would expect a better
performance. The query involves only one DataContext.
Is there anything wrong in the above operation? Am I missing something?
Or such long time is a known detail?
Best regards,
Alessandro
//
