Kana/Crystal Reports Database and Performance

[jpmackl]

Hi, We run an application called Kana - We have been seeing some performance issues lately. We currently run Crystal reports against the live database while user are in using the application, we also have DB maintenance jobs that run at night & crystal reports during that time frame - The Kana application is used 7x24.

Question:

1. Is anyone using Kana/Crystal reports - how do you run your reports? Are you seeing any issues?
2. Is it possible to copy the Kana Oracle database to seperate databse for Crystal Reports?
3. We currently have max Crystal Reports to run at 5

Any recommendations would be very helpful!!

Thanks!

 

[synapsevampire]

Oracle has what's called a "snapshot" which might be a good fit for your needs.

I'm not familiar with Kana, however it's common for people to set up separate aggregate or datamart tables to handle reporting so that reports don't interfere with production requirements.

Not sure what this means "3. We currently have max Crystal Reports to run at 5", I assume that you run the most reports at 5.

Perhaps this means in the morning, in either case, making a snapshot (copy) of the relevant tables, and/or creating some aggregate tables to speed up reporting should help.

-k

 

[jpmackl]

3. We currently have max Crystal Reprots to run at 5. Somehow either in Crystal or Kana Application - they have a scheduler of some sort and they execute several reports to run, but some how throttle the number to 5 max reports running at one time. I hope this clarifies...

Thanks for the tips.

 

[synapsevampire]

That's probably a setting in the registry, or it may be a licensing concern, or even Crystal Enterprise if your product is bundled with it.

Try posting the version of Crystal used, and if Crystal Enterprise is used.

-k