Help on Performance

HCL Domino Domino Forum
1

Hi All,

I am planning to develop a web application which connects to DB2 database using ODBC. Database has about 500,000 (5 lakhs) records which might grow o about 600,000 in a 2-3 years.

There will be about 500 users accessing these data using several views.

  1. Is it recommended to access the data from DB2 on the fly?

  2. OR do you recommend the data to be synchronized daily to a Domino database?

  3. Will it take a long time to index the views if we keep such a big volume in a NSF?

Regards,

Buwaneka

2

Subject: RE: Help on Performance

  1. Is it recommended to access the data from DB2 on the fly?It depends how you plan to use the data. It’s certainly not out of the question, but I would use DB2 directly in LEI, DECS or LC LSX, rather than via ODBC, for best performance.

  2. OR do you recommend the data to be synchronized daily to a Domino database?

That’s another good approach, depending what exactly you’re doing. Just make sure it’s really synchronized, and not all deleted and replaced daily.

  1. Will it take a long time to index the views if we keep such a big volume in a NSF?

Shouldn’t be too bad, especially if you don’t go hog-wild and create a hundred views.

3

Subject: RE: Help on Performance

Hi Andre,Thanks for your response.

I will create about maximum of 10 view.

My concern is the performance since there will be about 500,000 records and 500 users.

would you recommend the Notes synchronization(incremental) or direct DB2 access?

Cheers,

Buwaneka

4

Subject: RE: Help on Performance

“It depends how you plan to use the data.”