Oops_my_bad Posted May 28, 2011 Posted May 28, 2011 What SQL edition is the OP running out of interest?
vikpaw Posted May 29, 2011 Posted May 29, 2011 What SQL edition is the OP running out of interest? I think 2008, as R2 wasn't supported when they upgraded, and it wouldn't have been wise to move to that when it was unsupported.
number34 Posted June 6, 2011 Posted June 6, 2011 (edited) Whether the problem is with SIMS or our particular SQL setup here the last few sets of individual reports I have produced have been very slow. The point about reusing old reports again and again should not really make any difference if using result sets for the data being inserted and I do not even want to recreate the report templates. Like Sivadam we have been using them since the AM6 but unlike him I think that the problem is SIMS related. Edited June 6, 2011 by number34 typo
vikpaw Posted June 7, 2011 Posted June 7, 2011 The only major issues we've had have been due to Client OS. Mostly Win7 coupled with Office 2010 and some very shoddy roaming profiles and redirect documents folders. Resetting profiles or running on XP have resolved the issue, so if it is something weird with SIMS it's more the way it interacts with the client rather than something intrinsically wrong. However, there are numerous threads on these client side issues so it would be good if they were investigated further. I've started getting "Error: Object Reference Not set to an instance of object" errors again for running regular data reports. Only solution is to reset profile - really frustrating.
number34 Posted June 7, 2011 Posted June 7, 2011 SQL express or full? Full, 2008. I should also add that I'm using Windows 7 and Office 2007 or 2010.
vikpaw Posted June 7, 2011 Posted June 7, 2011 Can you try an XP box, even a VM? I'm about to reinstate one of mine for reports purposes.
number34 Posted June 10, 2011 Posted June 10, 2011 Hi Vik, just printed about about 170 reports that contain about 26 results plus 13 class teacher inserts. Used a terminal server XP session with Word 2003. My impression was that it was about 25% quicker but difficult to judge exactly as I was using a different printer setup. I will try to run a direct comparison and get more accurate figures later.
LosOjos Posted June 10, 2011 Author Posted June 10, 2011 (edited) Hi Vik, just printed about about 170 reports that contain about 26 results plus 13 class teacher inserts. Used a terminal server XP session with Word 2003. My impression was that it was about 25% quicker but difficult to judge exactly as I was using a different printer setup. I will try to run a direct comparison and get more accurate figures later. Just my 2p - to make a better benchmark, you really have to take the printer out of the equation. What I do is export all the reports in to a folder, then sort them by creation date and see how long it took to complete from start to finish. I then repeat on any machine I want to draw a comparison on. EDIT: added bonus to this technique is that by using a script [see here: http://www.edugeek.net/forums/mis-systems/43551-sims-assessment-manager-individual-reports.html#post686430] you can print them all afterwards, giving you the freedom to leave them running over night ready for printing the following morning. Edited June 10, 2011 by LosOjos 1
PhilNeal Posted June 10, 2011 Posted June 10, 2011 Number34 - how long did it actually take? I still haven't had anyone contact me about this despite 3? reminders that the offer to investigate is there.
number34 Posted June 13, 2011 Posted June 13, 2011 Phil,Vik et al, I did a comparison between using the terminal server, XP and Word 2003 and a laptop with Windows 7, Word 2007. Printed 3 sets of reports with each and was surprised at the result. On the first 2 m 54 s to first page appearing from printer, on the second 1 m 50 s to first page. So I was wrong but the actual printing took twice as long on the second so I now need to look more carefully at the printer driver settings.
vikpaw Posted June 14, 2011 Posted June 14, 2011 Phil,Vik et al,I did a comparison between using the terminal server, XP and Word 2003 and a laptop with Windows 7, Word 2007. Printed 3 sets of reports with each and was surprised at the result. On the first 2 m 54 s to first page appearing from printer, on the second 1 m 50 s to first page. So I was wrong but the actual printing took twice as long on the second so I now need to look more carefully at the printer driver settings. I hope it was a fair test with comparable specs on the hardware. How long does the printing take?You and @LosOjos should take up Phil's offer of investigation, it could help resolve issues for many.
LosOjos Posted June 14, 2011 Author Posted June 14, 2011 I hope it was a fair test with comparable specs on the hardware. How long does the printing take?You and @LosOjos should take up Phil's offer of investigation, it could help resolve issues for many. I would happily, but unfortunately I know the school would reject any request for consultancy at the moment due to our budget. For now, running reports overnight and printing them via my script (provided by a member on here - I must start taking note of names!) the following morning works fine for me
vikpaw Posted June 14, 2011 Posted June 14, 2011 I would happily, but unfortunately I know the school would reject any request for consultancy at the moment due to our budget. For now, running reports overnight and printing them via my script (provided by a member on here - I must start taking note of names!) the following morning works fine for me I had hoped that @PhilNeal 's offer was not linked to financial recompense, more of a means to rectify the issues and ensure that knowledge is shared with others.
number34 Posted June 14, 2011 Posted June 14, 2011 I hope it was a fair test with comparable specs on the hardware. How long does the printing take? Vik, difficult to compare the hardware spec as I haven't a clue where to start with the thin client. Laptop reasonably good, i3 and 2 gb ram. I did not time the actual printing but on the laptop there was a definite gap between different pupil reports whereas on the thin client the printing was continuous.
vikpaw Posted June 14, 2011 Posted June 14, 2011 it's a shame you cant test a win 7 thin client or an xp laptop, otherwise it's not a fair test.
PhilNeal Posted June 14, 2011 Posted June 14, 2011 I wasn't after cash! Just want to find out what the issue is and hopefully resolve. Please don't all rush together I'm out for the next 3 days!! 2
joseph Posted June 22, 2011 Posted June 22, 2011 Sorry if this is out of date and you already found a solution, but we had the same problem, and the solution was to install PDF Factory pro, set the default printer to PDFFP and the select all the students and hit print, that way you can get a file with all the reports in minutes (depending of the size of the class/year group).... PDFFP will put all the files in a single file without opening office x times and hangin your pc... After that, it is much easier to send it to the printer....
vikpaw Posted June 28, 2011 Posted June 28, 2011 (edited) We printed lots of reports yesterday, and the direct printing just isn't working out right. [Win7 - Office 2010]. Keep getting the SIMS has stopped working error, and then it crashes out. It's not a normal SIMS error, it's coming from Windows and whatever is doing the actual printing because i can see the reports files that are generated in the temp folder it's only at print time it crashes out. Incidentally, that is going to C:\users\\appdata\local\temp\ I went straight for the export to folder and print later option. Can't say it was slow, the DH thought so, but around 10-15 secs per report isn't too bad, considering it's a full report with 15 pages, 10 ish results to a page, plus 1 comment, and the teacher name. The template probably only has 15-20 pages tops as it's KS3 so not many options. So it's at the most 1 sec per page, which i though was reasonable and has been the norm for me here and at other schools. I had major problems printing, but that's another story, and probably better off in one of the other threads regarding bulk printing xml docs. Edited June 29, 2011 by vikpaw EDIT: correct folder location
PhilNeal Posted June 28, 2011 Posted June 28, 2011 I think this is a reasonable speed! I used to have to print for 48 hrs when I first started profiles some 20+ years ago!
Sivadam Posted June 29, 2011 Posted June 29, 2011 (edited) Nice one Phil! When we used to use Profiles6 it wasn't quite that long, but it was certainly a lot slower than it is now. And that was with extremely simple reports compared to those that we create now! Edited June 29, 2011 by Sivadam
vikpaw Posted June 29, 2011 Posted June 29, 2011 I think this is a reasonable speed! I used to have to print for 48 hrs when I first started profiles some 20+ years ago! Well, dotmatrix was rated in characters per min not pages! I thought my speeds were perfectly fine, it's just the printing that is now a pain.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now