Skip to Content
author's profile photo Former Member
Former Member

64bit and dual core questions

Hi,

We are heavy Crystal Report 10 users and are considering upgrading. I understand that the new Crystal Report 2008 supports 64bit platforms and will run on dual core machines. My question is, does the new Crystal Report 2008 take advantage of the 64bit platforms and dual core machines? And should we expect to see a dramatic performance improvement.

I ask this question as some of our reports can take upwards of 7 hours to crunch and we are considering the move to 64bit and dual core technologies to speed up our processing.

Any suggestions would be greatly appreciated.

Les Elton

Network Admin.

ABC Recycling Ltd

les@abcrecycling.com

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on May 02, 2008 at 12:46 AM
    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      With all those who have started to use Crystal 2008, for those who have embarked on the change to 64bit.

      Is there a speed increase when using Crystal 2008 on a 64bit machine ?

      Or should I expect the same speed ?

      Les Elton

  • Posted on May 01, 2008 at 04:53 AM

    How many records are you returning on a 7-hour report..?

    Is that 7-hour crunch on the CR-side or on the SQL/DB side...?

    You can test this by copying the SQL from the report into your DB tool, and seeing how long the query alone is taking.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hey Les,

      I'm curious what your answer is to Mark's question (on running the query by itself).

      That's really not a lot of records at all.

      Our stuff goes against millions of records, in Cobol, and nothing I know of approaches 7 hours.

      Are you doing all the processing in Crystal ? Even so...

      At WebMD we ran a test against 1M records, it returned 30k records, there was a chart, a sub, formulas, etc. Running directly against Oracle, it took 27 seconds. After building the data warehouse (SQL), using .Net and a report with a dataset, we got it down to 4 seconds.

      I'd hate to see you put out the bucks and find out it's not what you need.

      The Panda

  • Posted on Jul 25, 2008 at 03:28 PM

    By default 32 bit applications do run considerably faster on 64 bit OS's. They are still limited to the 32 bit 4 gig memory space and 32 bit API set but due to the nature of 64 bit OS's 32 bit applications just run faster. Not sure how much faster you will see but it should be noticable.

    Check Pervasives WEB site for currently supported versions also. You will need to stick with 32 bit client/server engine depending on if you are using the Server or Work Group version of Pervasive. If Pervasives client is capable of thunking 64 to 32 bit data then it should also work in CR.

    You may want to consider moving to Crystal Report Server which is designed for small companies. This product allows you to schedule reports so they are ready for you in the morning and can be sent to the users who need them.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.