1. Home

Product groups

Support

Batch Update - WeOnlyDo Discussion board

Batch Update (wodHttpDLX)

by Skc, Tuesday, October 02, 2007, 09:28 (6060 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
  2257 views

Re: Batch Update

by wodDamir, Tuesday, October 02, 2007, 09:33 (6060 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
  2246 views

Re: Batch Update

by Skc, Tuesday, October 02, 2007, 09:46 (6060 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
  2269 views

Re: Batch Update

by wodDamir, Tuesday, October 02, 2007, 10:01 (6060 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
  2243 views

Your support is fantastic.

Douglas Michael Panchyshyn
The Net Software Group

Your customer service was excellent, and I will look at your products in the future for precisely that reason.

Charles Taylor
InterWeave, Inc.

Many thanks for your excellent support service. I can see why you have a long list of excellent testimonials on your website.

Martyn Walker
Batmore Technolgies

Congratulations on an excellent product and first rate support!

Sander Pool
Rhapsody Networks

...not only that you provide these components at very reasonable cost, your responsiveness to emailed technical questions is simply outstanding...

Michael Thomas
ClownRed Media

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

...your service has been phenomenal. It's always quick and you are there when I need you.

James Newman
Castleberry Investments

Many thanks for your excellent support service. I can see why you have a long list of excellent testimonials on your website.

Martyn Walker
Batmore Technolgies

Fantastic product by the way, it has helped us tremendously on a daily basis. Keep up the good work.

Ben Lewis
Waterson Consulting Ltd.

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