 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / Languages / VB.NET / September 2005What's the best performatic collection?
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 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/default.asp?url=/library/en-us/cpref/html/frlr fsystemdatadatatableclassprimarykeytopic.asp Ken -------------------- > Hey guys. > [quoted text clipped - 15 lines] > > Cesar 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/default.asp?url=/library/en-us/cpref/html/frlr fsystemdatadatatableclassprimarykeytopic.asp Ken -------------------- > Hey guys. > [quoted text clipped - 15 lines] > > Cesar 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/default.asp?url=/library/en-us/dv_vbcode/html/ vbtskcodeexamplesearchingrecordindatatable.asp Ken -------------------- > Thanks for reply, Ken. > [quoted text clipped - 41 lines] >> >> Cesar Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.