nailed it in one!
Yup, the data is so far from normalised it might as will be in text files. The excuse I heard was that it is due to legacy programs and support.
Re-writing the code that deals with the data wont make it any faster, it might look a bit prettier but it will still access the data in the same way. I think SQL Express is definitely worth checking, short of that try profile what your SQL server is doing - you might just find it's obscenely complex queries to get minimal data out as localzuk & bossman have said.
Absolutely right, but rewriting the data access code may allow you to use better back-end methods for storing said data (normalized tables, etc), which is what I think @localzuk was getting at.
Indeed. This is why using an MVC programming architecture is a good thing when making data handling programs - even if you get the database massively wrong at first, you can fix it without major changes to your presentation layer!
So, effectively, you can massively improve ancient programs without much effort.
I really wish they would update options, nova and exams to use proper SQL and have the new interfaces
Issue is Capita motto is, if it ain't fix, don't touch it, unless you can sell it. The benefit of not upgrading everything and leaving some bits in an old version is you don't have to re-tender because it's not a "new" product. Still that's become more popular in "cloud" world as you can do faster build cycle. Plus side of being in the UK is that the government cloud allows you to see what people are spending money on in the cloud - Sales Information - G-CloudG-Cloud
That's assuming they go down the proper paths of course.
Am I the only one who feels they are taking some unfair stick on here lately? :confused: Discover was provided free and even then it had to answer a challenge from other providers over anti-competition laws. Performance Management was also meant to be free but had to be charged due to the same issue.
Some parts do need a serious update, I can't see why we have Windows 3.11 era programs like Options still kicking around in the admin back-ends. But I have been watching SIMS improve considerably over the last few years for teacher facing parts of the system as the MIS market has opened up.
My client load time is 26 secs. It seems alot higher than everyone elses. We have SIMS Server on a VM with 16GB RAM and 4 vCPUs. We have full sql. Our clients are Core2Duo 2.80GHz Win 7 64bit 4GB RAM.
Once SIMS is running it seems to be ok. 4 secs to find "smith".
Loading SIMS first time takes 26 secs, close it and log in again and it takes 8 secs.
Anything I can do to improve that first load time?
@CAM I think the stick comes from people being sick of issues. We've almost gone back to the same era of annoyances as 5 years ago - where each update was a nightmare. How many of the latest updates have been withdrawn or re-released?
Combine that with the fact the underlying database is *still* a mess, however many years after SIMS .Net appeared, and the fact that there are still modules which are, as you say, 3.11 era stuff, and people get a bit annoyed.
150+ student school (SQL 2008 R2, Solus 2, Discover)
HP ML370 G5 (6+ year old H/W), VMware ESXi 4.1, Win 2003 STD SP2, 3GB RAM, 2 Cores Xeon @ 1.8GHz, 2 x 72GB 10K SAS drive (RAID 1+0), 2 x Gbit NIC
Intel i3-3220 3.3GHz, 4GB RAM, 250GB HDD @ 7200 RPM, Win 7 Pro SP1 x86
2.31 Seconds Client Load time
5.52 seconds Reports >> Students >> addresses >> Year 7 >> 1 Reg Group
0.76 Seconds Search "Smith" student name in main screen search box
Sims.mdf - 1.85 GB
Sims.ldf - 184 MB
Simsdiscover_Primary.mdf - 73 MB
Simsdiscover_Primary.ldf - 69 MB
Thankfully, for us, ours is relatively 'fast'.
Edited bit: I should add that at first run time, the load time is 18 seconds - less on the server. Any subsequent client runs after the first run time loads in < 5 seconds.
@CAM agree about Discover, whoever got that pushed though Capita needs a medal.