c# - Updating a large data set via SQL command -



c# - Updating a large data set via SQL command -

i'm working import file has 460,000 rows of info within it. each row consists of id , quantity (eg. "1,120"). info read file, should used update each individual row within database (eg. update item set quantity = qty id = 1).

the problem i'm having, though, beingness able run query efficiently. if run individual query each line, it's not going work (as i've found out hard way).

i'm not in way sql user , i'm learning, i've seen, web doesn't seem have useful results on this.

i wondering if had experience updating such big dataset, , if so, willing share methods used accomplish this?

460k rows isn't lot, should okay there.

i'd recommend importing entire dataset temporary table, or table variable. solution working, start creating actual physical table, can either drop or truncate while getting working.

create table, import info it. then, table update based on bring together import table.

discard import table when appropriate. 1 time working how want to, can entire thing using stored procedure, , utilize temporary table handle imported info while working it.

c# mysql sql

Comments

Post a Comment

Popular posts from this blog

model view controller - MVC Rails Planning -

model view controller - MVC Rails Planning - i'm starting rails , i'm building app stores films info, user can watch film , give grade on web application. i have coded cinema model, controller , views. now, have 2 questions: should need create model , controller grading? in case, should create or should wait , create first users model , controller? yes, on model , controller grades. that'd feasible way maintain track of who's graded what. it's create first, i'd start users, since grades depend on both films , users. ruby-on-rails model-view-controller
Read more

ruby on rails - Devise Logout Error in RoR -

ruby on rails - Devise Logout Error in RoR - while using devise in ror, encountering unusual error when trying log out url different root url. displays me : actioncontroller::invalidauthenticitytoken in devise::sessionscontroller#destroy" for illustration if rooting path after log in '/structure', , seek log out '/general' error, while logging out '/structure' fine. any help highly appreciated. ruby-on-rails ruby devise
Read more

html - Submenu setup with jquery and effect 'fold' -

html - Submenu setup with jquery and effect 'fold' - i want open submenu jquery effect fold, problem if user "hover effect" fast menu remain open, how can avoid this, jquery code is: $('ul.mainmenu li').hover( function() { $(this).children('ul').show('fold', 570); }, function() { $(this).children('ul').hide('fold', 500); } ); my jsfiddle link is: http://jsfiddle.net/9wkbf/ updated fiddle the reason behind problem is, first event $(this).children('ul').show('fold', 570); queued , until completes, sec animation not start. the next snippet can workaround $('ul.mainmenu > li').hover( function() { $(this).children('ul').show('fold', 570); }, function() { $('ul:not(.mainmenu)').hide('fold', 500); } ); *important note : work current scenario. jquery html css
Read more