jwcolby
jwcolby at colbyconsulting.com
Tue Apr 29 13:33:22 CDT 2008
It is going to take 50 hours because an external program which does the name parsing will take at least 40 hours just to parse the data. Writing to the database is only about 25% of the total time. If you managed to completely eliminate my database update time it would still take about 40 hours to complete. Thanks for the offer though. John W. Colby www.ColbyConsulting.com Robert L. Stewart wrote: > Which is why it is going to take 50 hours instead of 2 or 3. > > > If you will give me an idea of what you are updating, I can send > you the SQL for the update. > > "I know how to do it with a hammer, therefor, I will make everything > a nail." > > Robert > > At 12:00 PM 4/29/2008, you wrote: >> Date: Tue, 29 Apr 2008 11:43:45 -0400 >> From: jwcolby <jwcolby at colbyconsulting.com> >> Subject: Re: [dba-VB] dba-VB Digest, Vol 54, Issue 28 >> To: "Discussion concerning Visual Basic and related programming >> issues." <dba-vb at databaseadvisors.com> >> Message-ID: <48174231.4070501 at colbyconsulting.com> >> Content-Type: text/plain; charset=ISO-8859-1; format=flowed >> >> > Yes, that is correct. He is ending up loading the records into memory. >> > Then passing individual updates back for each row of data that he >> > changed. >> >> Yes, and most records have updates. >> >> > This method is not designed for doing large datasets like he is doing. >> > >> > It should be done on the SQL Server side. >> >> ROTFL. That is a definite NSS. >> >> Unfortunately I am not a DBA and with the responses I get from the SQL >> group I am not even going there. I can do this purely in VB.Net (it is >> cranking as we speak) so I will. >> >> > Just what are you updating...the UPDATE statement you would use to >> > do what you are doing. >> >> No idea. I thought I could find out from the DA after the command >> builder was finished building the update statement but I am getting an >> error if I try to access the update property. >> >> John W. Colby > > > _______________________________________________ > dba-VB mailing list > dba-VB at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-vb > http://www.databaseadvisors.com > >