I have a query that returned about 7000 records using livecycle dataservices 2.5 and Flex SDK 3.0. I expect this to take a few seconds, but it take 25-30 seconds to get the result back. The VO I am returning has about 42 properties of int, Strings and Dates. No other collections. The query itself is under a second and is just against one table. The server resources are not close to getting maxed out.
On the arraycollection I tried disablingAutoUpdate. On the dataservice, I disabled the autosync, automerge, autoSaveCache and autoCommit. I have been able to return large datasets before, but not using LCDS. Any ideas how to get all the records back at once would be greatly appreciated.
Thanks