1. Home

Product groups

Support

Batch Update - WeOnlyDo Discussion board

Batch Update (wodHttpDLX)

by Skc, Tuesday, October 02, 2007, 09:28 (6263 days ago)

I intend to read my windows Database and using wodHttpDLX's post method to update a Web-based form/database with corresponding data. This will be a batch run. I have 2 questions:

(1) Is it better to let post method do the auto-connection or is it better to explicitly do a Connect once, then at end of batch run, to do a Disconnect?

(2) SInce this is a batch run that will run after working hours, if there are any errors displayed by wodHttpDLX - will there be any problem, and is there a way to write the error messages to a Text file that can be viewed when it is finished?

Thank you
Skc

locked
  2444 views

Re: Batch Update

by wodDamir, Tuesday, October 02, 2007, 09:33 (6263 days ago) @ Skc

Hi Skc,

1) It totally depends on you. When you call Post it will connect, do whatever it is indended to be done, and then disconnect.

2) Not by the component itself (except for the debugfile, but i don't reccomend it as it could get huge). You can use the implemented functions for that purpose, like FileSystemObject in VB.

Hope I helped.

Regards,
Damba

locked
  2393 views

Re: Batch Update

by Skc, Tuesday, October 02, 2007, 09:46 (6263 days ago) @ wodDamir

Regarding the question (1), there may be, example 500 records that need to be POST 1 by 1 via wodHttpDLX. So if I do a 1-time Connect first before this batch update, will it be more efficient?


locked
  2453 views

Re: Batch Update

by wodDamir, Tuesday, October 02, 2007, 10:01 (6263 days ago) @ Skc

Skc,

We haven't performed that kind of tests. However i assume it would, since you'd skip each connection process, but i'm not sure if it's going to be significant.

Regards,
Damba

locked
  2424 views

I really like these products - they are consistently first rate!

David Witten
WWR Development, Inc.

...what I really like is that wodSSH and wodSFTP components work excellently and are constantly being improved...

Steven Jones
SABIEN project

I've heard that you are amazing with your replies coming back so quickly - and now I've seen the speed in which you reply first hand.

Andrew Narracott
Sun Computer Consultancy

Thank you so much for your hard work and commitment in producing well thought-out solutions. WeOnlyDo is very committed to customer satisfaction!

Mike McPherson
Nokia Inc.

We have recently completed a large 1200+ location project where reliable Telnet and SSH connectivity was required. wodSSH worked flawlessly and allowed our staff to complete our project ontime and within budget.

James Sievers
Harbor Technologies

It is very refreshing to find such helpful, knowledgeable and quick responding technical support.

Jason Sears
CompuSource Systems, Inc.

Thank you so much for your hard work and commitment in producing well thought-out solutions. WeOnlyDo is very committed to customer satisfaction!

Mike McPherson
Nokia Inc.

...with the SFTP interface you produced, everything was so simple to understand, we were able to start coding almost immediately!

Zack Menendez
Mapframe Corporation

Thank you for the great customer service ... I am really impressed with the wodSSH ActiveX control.

Andrew Ross
Kiwi Enterprises

Thank you so much for your hard work and commitment in producing well thought-out solutions. WeOnlyDo is very committed to customer satisfaction!

Mike McPherson
Nokia Inc.