Skip navigation
Currently Being Moderated

LCDS 2.5 - Dataservice is very slow

Oct 16, 2013 4:32 PM

Tags: #flex #lcds #dataservice

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

 
Replies
  • Currently Being Moderated
    Oct 22, 2013 11:12 AM   in reply to Ukie

    A few things to check:

    1. what is a query execution time on DB side?

    2. do you have a class definition on destination level?

    3. does the class (if defined) match properties to result set?

     

    All these may greatly affect the resulting performance.

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points