Hi,
Within every 1 second duration,I want to find 1 or 2 dataObjects with DataRows
query in a table that has approximately 3000 entity. For performans evaluation,
I prefer the DataRows but I consider is not increase 2x or 5x the performance
of the system. Can you hint me for increasing the performance or did I use the
datarows in correct form. And I want to know when I use datarows query, is
dataContext cache the objects in the buffer. If not, is dataContext cached
query increase the performance instead of datarows? And setRefreshingObjects
(true) means fetching the object from database for every call of query.
Code:
Expression qualifier = ExpressionFactory.matchExp(
PersonelCard.CARD_NO_PROPERTY, cardNo);
SelectQuery query = new SelectQuery(PersonelCard.class,qualifier);
query.setDistinct(true);
query.setCachePolicy(GenericSelectQuery.SHARED_CACHE);
query.setRefreshingObjects(true);
query.setFetchingDataRows(true);
List cards = context.performQuery(query);
This archive was generated by hypermail 2.0.0 : Tue Jan 17 2006 - 07:55:20 EST