HOw to group data

View: New views
2 Messages — Rating Filter:   Alert me  

HOw to group data

by Ignacio Romero Colomo :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi All,

I'm reading a csv file in Air, csv file contains data as if it were a
database table, when user selects a column (once the datagrid is populated
with this csv) I have to read the table and group data to define a
dataprovider for flex charts.(i.e. group number of sales per week when I
have a row per each sale with the week in one of the fields of this row)

When ths csv file is only about 2k lines everything works fine, but the
problem is when this csv is really big (i.e. 11k lines).

Whats the best solution to improve performance for this process, an
arraycollection is not valid for big sets of data. I don´t know if there is
an equivalent for hashtables in flex, or if there is a better way to do what
I'm trying, maybe there is a way to deal with data using like sql senteces
or something similar...

can you please help to find the best solution.

thanks-!!!!!!!!!!!

Piriñaca.

Re: HOw to group data

by wrhinfl :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

hashtable in Flex is Dictionary or Object.

Other options I am not sure about.

--- In flexcoders@..., Ignacio Romero Colomo <murcialito@...> wrote:

>
> Hi All,
>
> I'm reading a csv file in Air, csv file contains data as if it were a
> database table, when user selects a column (once the datagrid is populated
> with this csv) I have to read the table and group data to define a
> dataprovider for flex charts.(i.e. group number of sales per week when I
> have a row per each sale with the week in one of the fields of this row)
>
> When ths csv file is only about 2k lines everything works fine, but the
> problem is when this csv is really big (i.e. 11k lines).
>
> Whats the best solution to improve performance for this process, an
> arraycollection is not valid for big sets of data. I don´t know if there is
> an equivalent for hashtables in flex, or if there is a better way to do what
> I'm trying, maybe there is a way to deal with data using like sql senteces
> or something similar...
>
> can you please help to find the best solution.
>
> thanks-!!!!!!!!!!!
>
> Piriñaca.
>