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. Ari -- --------------------------> Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A
