If parallel is going to have any benefit you have to be using separate object contexts to avoid locking the same DataRow cache. On Wed, Mar 8, 2017 at 5:59 AM Musall, Maik <[email protected]> wrote:
> > > Am 08.03.2017 um 10:56 schrieb Aristedes Maniatis <[email protected]>: > > > > On 8/3/17 6:54pm, Musall, Maik wrote: > > > >> regular SelectQuery: 25888 ms for 1291644 objects > >> DataRowQuery alone: 14289 ms for 1291644 rows > >> DataRowQuery sequential instantiation: 6878 ms for 1291644 objects, sum > = 21167 > >> DataRowQuery parallel instantiation: 7351 ms for 1291644 objects, sum = > 21640 > >> DataRowQuery with iterator: 22484 ms for 1291644 objects > >> DataRowQuery with batch iterator of 100 each: 21219 ms for 1291644 > objects > > > > What about trying the new M5 release from yesterday and its ability to > select just the columns you need. You'll just get a list of column data > instead of a simpler object model, but it might be faster. > > > > This is M5 already (M6-SNAPSHOT really). But I need the full objects > because I need to do computations on them using the business logic > implemented in the DataObject class. > > Maik > >
