Page 2 of 2 FirstFirst 12
Results 11 to 16 of 16

Thread: CWebList Optimization

  1. #11
    Join Date
    Feb 2009
    Location
    Brazil
    Posts
    5,446

    Default Re: CWebList Optimization

    Yes. Was assuming that was the case

    thanks for complementing it
    Samuel Pizarro

  2. #12
    Join Date
    Jan 2014
    Location
    Italy
    Posts
    219

    Default Re: CWebList Optimization

    Hi Harm,
    I would like to make cWebList paging results of a big result set of an ESQL query. Actually I populate cWebList that uses ESQL in manual mode. Is there a different way to populate an ESQL cWebList so that she can page the results?

    Thank you very much
    Luca

  3. #13
    Join Date
    Mar 2009
    Location
    Adelaide, South Australia
    Posts
    477

    Default Re: CWebList Optimization

    Luca,
    While I've not tried this I can make a suggestion. If you load the whole result set in OnManualLoadData as you're doing now but instead of sending it straight to the Client you save it in a Server Web property, possibly even paginated, then you can read data from this property and send it to the list a page at a time. Of course, if the data is changing rapidly the stored data could become stale. In this case you might want to reload the property every call which would slow things down a bit.
    Ian
    The most important leg on a three legged stool is the one that's missing.
    Murphy's Law (2)

  4. #14
    Join Date
    Feb 2009
    Location
    Hengelo, Netherlands
    Posts
    10,869

    Default Re: CWebList Optimization

    Luca,

    You could make an SQL view from the ESQL statement and then use the SQL view as a ordinary table and make the weblist data aware.
    Regards,
    Data Access Worldwide
    Vincent Oorsprong

  5. #15
    Join Date
    Feb 2009
    Location
    Adelaide, South Australia
    Posts
    2,863

    Default Re: CWebList Optimization

    I can concur that Vincent’s answer is working great. However I think a reference to a help page or blog is warranted.
    Not sure if there is one, other than some slides you might find from a past presentation.
    Hopefully daw can add a link.
    Marco Kuipers
    DataFlex Consultant
    28 IT Pty Ltd - DataFlex Specialist Consultancy
    DataFlex Channel Partner for Australia and Pacific region
    Adelaide, South Australia
    www.28it.com.au

  6. #16
    Join Date
    Feb 2009
    Location
    Brazil
    Posts
    5,446

    Default Re: CWebList Optimization

    this would be the "easiest" and effective approach.
    Samuel Pizarro

Page 2 of 2 FirstFirst 12

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •