Is DECs a good choice to push data to MYSQL?

HCL Domino Domino Forum
1

I have never used DEC’s, but it sounds like it would fit my needs.

I have a large notes database that I want to push data from into MYSQL for ad hoc reporting purposes. I need to keep all of the data in notes, just push it to MYSQL and keep MYSQL up-to-data when changes occur in the notes database.

I was planning on doing this with LotusScript, which I am familiar with. However, if DECS can do this for me with little effort that may be the best answer.

Will DECs have a noticable impact on the save times for users?

Is DECs stable?

Will DECs freak-out my server if MYSQL becomes unavailable?

Anything else I should think about?

Thank you for any insight you can provide. I have found answers to some of these questions in the documentation, but I would feel more comfortable hearing from people that have done it rather than Lotus documentation.

2

Subject: RE: Is DECs a good choice to push data to MYSQL?

To make a copy of data for reporting purposes, I wouldn’t choose DECS. DECS is stable, but it seems to me your fears are well-founded, of performance impact and issues if the MySQL server is down or unavailable.

Disclaimer: I haven’t actually done any work with MySQL, and I’m one of the authors of the documentation you wanted a second opinion about, but FWIW.

3

Subject: RE: Is DECs a good choice to push data to MYSQL?

Thank you for your response. I guess I’ll go with the LS:DO option.