Re: need ideas on multi threaded db update
- From: "Andrew Morton" <akm@xxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 9 Mar 2006 11:37:41 -0000
cj wrote:
I have to take all records in a SQL db that have an empty val_code
field and process and update the records with a code number in the
val_code
field.
The processing is done by sending select info from each record to a
remote server. The remote server returns the code number to be put in
the val_code field. The remote server will allow me to have up to 5
"sessions" open with it at a time.
How is the val_code derived from the data? If there are a limited number of
val_code values then you could get them all in one go, or at least implement
a local cache (Array/ArrayList/whatever else might be appropriate) so you
don't have to query the remote server so much.
Are you using one database to update another database on a different
computer, or is it all within the same database? If the latter then surely
it would be more efficient to do it all in a stored procedure in the
database.
Andrew
.
- References:
- Prev by Date: Re: UDPState
- Next by Date: Re: "VB (9) Rocks" slide show
- Previous by thread: RE: need ideas on multi threaded db update
- Next by thread: Re: need ideas on multi threaded db update
- Index(es):
Relevant Pages
|
