Hello,
I have a quick question about how file attachments are handled when using DB2 as the storage for Lotus Domino.
I have an application which contains lots of documents. The performance are beginning to decrease. I was wondering if this is because the SQL query returns too much rows or if this is because we have too much file attachements (pdf, xls, …)?
When using regular views (non Query Views), the perfomance is still really good (using the same subset of documents). When using Query Views, it can takes up to one minute before seing the view.
We’ll probably split the data in more than one database… and try to display fields that are really necessary in the view… but I was wondering if file attachements have an impact on the performance of a QV? How does DB2 deal with file attachments?
Thanks!
BTW, I am pretty sure it used to have a specific DB2 Integration forum… where is it now?