Professional Web Applications Themes

Dataset Population Very Slow - Macromedia Flash Data Integration

A dataset of 100 fields and variable length is populated in AS2 from a Flash remoted query result. The query result arrives from the CF server very quickly. The dataset fields are each bound to individual TextInput boxes. Populating the dataset with this AS2 script: ds1.addItem({ProductID:qryRow.Frame, ImageID:qryRow.ImageID............(for 5 of the 100 dataset fields) It works OK, but takes about 0.5 sec per dataset row to populate. If the number of bindings is reduced, the population speed increases, so the problem appears to be related not to the number of dataset fields, but the number of bindings. Similarly, when reading the ...

  1. #1

    Default Dataset Population Very Slow

    A dataset of 100 fields and variable length is populated in AS2 from a Flash
    remoted query result. The query result arrives from the CF server very quickly.
    The dataset fields are each bound to individual TextInput boxes. Populating the
    dataset with this AS2 script:

    ds1.addItem({ProductID:qryRow.Frame, ImageID:qryRow.ImageID............(for 5
    of the 100 dataset fields)

    It works OK, but takes about 0.5 sec per dataset row to populate. If the
    number of bindings is reduced, the population speed increases, so the problem
    appears to be related not to the number of dataset fields, but the number of
    bindings.

    Similarly, when reading the dataset into an array, processing is very slow.

    I've seen a couple of other postings related to dataset performance issues,
    but not this specifically. I have workaround for the initial population
    problem, but sooner or later the dataset elements have to be read into the
    array.

    Suggestions? Thank you.

    Bill

    WHC325 Guest

  2. #2

    Default Re: Dataset Population Very Slow

    Yeah, I have a suggestion. I have a similar deal where I load a bunch of
    records into the dataset, but I only allow the user to view 15 at a time, then
    they scroll through the dataset and add the next fifteen upon request, would
    that work for you?

    conquerors04 Guest

  3. #3

    Default Re: Dataset Population Very Slow

    Reading a portion of the data isn't an option for this app. What I've done to
    overcome the dataset performance issues is use 2 dimension arrays and bind to
    components in AS. Very fast and have tested with 500,000 data points without
    issues.

    WHC325 Guest

Similar Threads

  1. Population pyramid
    By kanpeter@graduate.hku.hk in forum Macromedia Flex General Discussion
    Replies: 0
    Last Post: July 25th, 10:02 AM
  2. Dataset.length(), dataset.hasnext() not working.. Why?
    By GmR in forum Macromedia Flash Data Integration
    Replies: 0
    Last Post: January 9th, 07:53 AM
  3. Replies: 2
    Last Post: October 31st, 02:43 AM
  4. Automatic population
    By John Vinson in forum Microsoft Access
    Replies: 0
    Last Post: July 11th, 05:21 AM
  5. heavy population of db
    By Tonny René Poulsen in forum Microsoft SQL / MS SQL Server
    Replies: 5
    Last Post: July 2nd, 03:19 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139