What's the best performatic collection?

[Cesar Ronchese]

Hey guys.

I'm using a DataView to store a lot (amoung 2000 lines) of configuration and
objects and this DataView is indexed by two columns.

That 2000 lines are created in a loop, with the DataView already indexed to
improve search, because I need to check if the record already exists before
create a new. The problem I noticed is this is too low to store new data,
perhaps because the index engine is not optimized for that kind of use.

My questions are:

1. is DataView really not good for that?
2. What the best collection or something I can use to do that job?


Cesar

 

[Ken Tucker [MVP]]

Hi,

When you add a primary key to a datatable you can specify more
than one column. If you use the 2 columns for the primary key you will get
an error when trying to add a duplicate row. Add the row in a try catch
block. If you get an error you are trying to add a duplicate.

http://msdn.microsoft.com/library/d...rfsystemdatadatatableclassprimarykeytopic.asp

Ken

 

[Cesar Ronchese]

Thanks for reply, Ken.

I would like not use the Try Catch, because it seems be a bit slow (the
first time is called, at least).

I've changed everything to a ArrayList collection and stored others arrays
in each item of the arraylist (and concatened that two IDs into one string).

The performance now turn terrific faster, but I don't know if is the best
form yet.

[]s
Cesar





Hi,

When you add a primary key to a datatable you can specify more
than one column. If you use the 2 columns for the primary key you will get
an error when trying to add a duplicate row. Add the row in a try catch
block. If you get an error you are trying to add a duplicate.

http://msdn.microsoft.com/library/d...rfsystemdatadatatableclassprimarykeytopic.asp

Ken

 

[Ken Tucker [MVP]]

Hi,

I am glad you found a method that works for you. You could also use
the datatable's find method to check for the record instead of catching the
error.

http://msdn.microsoft.com/library/d...btskcodeexamplesearchingrecordindatatable.asp

Ken
--------------------

Thanks for reply, Ken.

I would like not use the Try Catch, because it seems be a bit slow (the
first time is called, at least).

I've changed everything to a ArrayList collection and stored others arrays
in each item of the arraylist (and concatened that two IDs into one
string).

The performance now turn terrific faster, but I don't know if is the best
form yet.

[]s
Cesar





Hi,

When you add a primary key to a datatable you can specify more
than one column. If you use the 2 columns for the primary key you will get
an error when trying to add a duplicate row. Add the row in a try catch
block. If you get an error you are trying to add a duplicate.

http://msdn.microsoft.com/library/d...rfsystemdatadatatableclassprimarykeytopic.asp

Ken
--------------------

Hey guys.

I'm using a DataView to store a lot (amoung 2000 lines) of configuration
and
objects and this DataView is indexed by two columns.

That 2000 lines are created in a loop, with the DataView already indexed
to
improve search, because I need to check if the record already exists
before
create a new. The problem I noticed is this is too low to store new data,
perhaps because the index engine is not optimized for that kind of use.

My questions are:

1. is DataView really not good for that?
2. What the best collection or something I can use to do that job?


Cesar