Is there a way to speed up refresh rate?

[mjstanton]

I am using CR 8.5 and a Lotus Domino/Notes database. My report draws on data from 2 "views". It seems to take forever to refresh the report. Someone suggested that the database is not "indexed". Our Lotus Notes "go-to guy" says he's "pretty sure" it is. How can we find out for sure? And is there any other way to speed up the time it takes the report to refresh?

TIA

 

[Naith]

The refresh can only be as fast as the query you're generating takes to run.

I would be inclined to pursue the indices argument - but bear in mind, that just because a database is indexed, it doesn't necessarily mean that your query will use the indexes.

Check the query you're generating. Any "Like"s or "Not In"s and the such will blatantly ignore all indexes. Additionally, if you have multi-key indexes in the index, and you're only selecting half of the fields that make up that multi-key index, then the index will be ignored there, too.

My advice is to take the query out of the report, and decipher the performance time directly on the database, and see if you can do anything to hone it down there.

All the best,

Naith

 

[synapsevampire]

I haven't worked with Notes and Crystal on a large scale, but this may help:

http://www.dominopower.com/issues/issue200006/crystal0600001.html

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[kenhamady]

Are these 'views' logical, i.e. and made up of multiple pre-linked tables, or is a 'view' the NOTES term for a single physical table?
Are the views coming from the same Notes database?
How is the performance with one view?
Are you linking the views together or using subreports?

If these are true views, linking them may be inefficient at the database, or possibly even forcing the processing to occur at the client. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[Guest_imported]

You need to avoid using more than one table per report when using Lotus Notes..
Alas,,.. Lotus Notes IS NOT a database..
Try to set up a view in Notes that does everything for you that you would do with your report qua selection and combining data etc.. Kinda server side processing if you wish to call it that.
Then use the one view..
Also "Indexing" in a view means... sort the column.
If a database is indexed and you see the little green "dot".. that means it is fulltext indexed.. not column specific and only interesting for your searches..