By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,417 Members | 835 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,417 IT Pros & Developers. It's quick & easy.

What's the best performatic collection?

P: n/a
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


Nov 21 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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/de...rykeytopic.asp

Ken
--------------------
"Cesar Ronchese" <ronchese*smlinfo.com.br> wrote in message
news:us**************@TK2MSFTNGP11.phx.gbl...
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

Nov 21 '05 #2

P: n/a
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

"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message
news:Os****************@TK2MSFTNGP12.phx.gbl...
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/de...rykeytopic.asp

Ken
--------------------
"Cesar Ronchese" <ronchese*smlinfo.com.br> wrote in message
news:us**************@TK2MSFTNGP11.phx.gbl...
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


Nov 21 '05 #3

P: n/a
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/de...ndatatable.asp

Ken
--------------------
"Cesar Ronchese" <ronchese*smlinfo.com.br> wrote in message
news:%2******************@tk2msftngp13.phx.gbl...
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

"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message
news:Os****************@TK2MSFTNGP12.phx.gbl...
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/de...rykeytopic.asp

Ken
--------------------
"Cesar Ronchese" <ronchese*smlinfo.com.br> wrote in message
news:us**************@TK2MSFTNGP11.phx.gbl...
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


Nov 21 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.