+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, Producing School Reports - Slow... in Technical; Hi Guys, Just wondered if there was anyone who may have had the same issue as me with WCBS PASS ...
  1. #1

    Join Date
    Oct 2010
    Location
    St. Albans
    Posts
    7
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Producing School Reports - Slow...

    Hi Guys,

    Just wondered if there was anyone who may have had the same issue as me with WCBS PASS whilst running reports.

    Basically we have installed PASS this year, after months of agro, and constantly slow performance, I have moved PASS to a new server (4 x Quad Cores, 12GB RAM, 15k SAS drives, Server 2008R2, SQL 2008 Full Edition), but the same issue persists, when I run a report it can take between 1 minute and 6 seconds and 3 Minutes 16 Seconds to display a report for a relativley small bunch of students, on SIMS this would take seconds.

    I have run a trace on the SQL server and run several index tuning tasks, there is still no difference. When running a trace the SQL transactions seem to come through in small, slow bursts from the main application, which i find concerning.

    It is also worth noting that if you click on the application during the report building process the application will freeze and crash. (On both the old installation and the new installation)

    Any thoughts?
    Last edited by asprisa; 13th December 2010 at 09:59 PM.

  2. Thanks to asprisa from:

    AngryTechnician (14th December 2010)

  3. #2

    ZeroHour's Avatar
    Join Date
    Dec 2005
    Location
    Edinburgh, Scotland
    Posts
    5,832
    Thank Post
    971
    Thanked 1,385 Times in 849 Posts
    Blog Entries
    1
    Rep Power
    457
    BTW we have the same issues. It looks like the client does all the actual processing/work and is single threaded so only 50% usage.
    The joy of the MIS that is pass. Our MIS people are screaming at us to fix it but we cant see what else to do and if your setup is slow with all that hardware there is nothing we can do.

  4. #3

    Join Date
    Oct 2010
    Location
    St. Albans
    Posts
    7
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    I kind of expected someone to say that, there is only so much you can do to a poorly built piece of software before throwing it out of a window!

    Thanks for replying!

  5. #4

    ZeroHour's Avatar
    Join Date
    Dec 2005
    Location
    Edinburgh, Scotland
    Posts
    5,832
    Thank Post
    971
    Thanked 1,385 Times in 849 Posts
    Blog Entries
    1
    Rep Power
    457
    Quote Originally Posted by asprisa View Post
    I kind of expected someone to say that, there is only so much you can do to a poorly built piece of software before throwing it out of a window!

    Thanks for replying!
    I am glad you posted it tbh as at least we know its probably not our setup.
    What client OS are you using?

  6. #5

    Join Date
    Oct 2010
    Location
    St. Albans
    Posts
    7
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    We are using primarily Windows XP Clients, Although I have tested it on a Windows 7 Professional N laptop with the same results.

    I think it might be easier to go to pen and paper next year!

  7. #6

    Join Date
    Mar 2009
    Location
    London
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Its all in the building of the reports and the number of tables you are pulling from. I did thier advanced reporting workshop and managed to turn 1 report that tooks 10 minutes to print into 1. It was very worthwhile.



SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 82
    Last Post: 9th June 2011, 06:52 PM
  2. Producing the School Calendar
    By Stuart_C in forum How do you do....it?
    Replies: 1
    Last Post: 10th May 2010, 06:58 PM
  3. Producing School Calendar
    By Stuart_C in forum How do you do....it?
    Replies: 9
    Last Post: 7th October 2009, 11:49 AM
  4. School Reports by Email
    By laserblazer in forum General Chat
    Replies: 6
    Last Post: 10th January 2008, 12:40 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •