JorgeA

Word 2007 files take forever to open in Vista (was: Will an SSD help?)

240 posts in this topic

Hello,

In my line of work I deal with some fairly hefty (4MB, 13MB) MS Word files featuring a mix of text and graphical elements, and I've noticed that they can take a loooong time to load before I can start working on them. Yesterday, as a test, I opened a 13,746KB file and started a stopwatch. Three minutes and 20 seconds of thumb-twiddling later, the file finally finished loading.

It doesn't seem to matter what other programs I do or don't have running at the same time. Therefore I'm thinking that maybe if I put these files on a solid state drive, I could load (and save) them faster and no longer need to sit around waiting or finding something else to do in the meantime.

FWIW, I use Vista Home Premium x64, and my PC (a factory-spec HP a6512p) has 4GB of RAM and a Pentium Dual E2200 CPU. I also use ReadyBoost (it does seem generally to speed things up for me). Needless to say, I don't have any USB 3.0 ports.

My research indicates that Vista doesn't support the TRIM command that helps to keep SSDs running faster for longer. But then I would only be using the SSD to store Word files, so it would take a long time to fill it to the point where performance would start getting affected. (And many SSD manufacturers have their own software to clean out their drives.) The most important question is: Is installing an SSD likely to significantly speed up loading and saving my Word files?

Thanks for any insights or information you might have on this!

--JorgeA

0

Share this post


Link to post
Share on other sites

If money is not a problem, you should go for a Fusion ioDrive. If it's somewhat of a problem, a RAID array of 6 class 10 SDHC cards will do nice. But usually both are too expensive as solutions. For normal mortals, A 4 GiB Gigabyte i-Ram is the best solution money can buy. But you'd have to load it the files at the start of a working day and backup them to safer media at the end of the day, just to keep on the safe side. All going well, the files keep there all right, so you just need to backup at the end of the day, each day, to keep safe, but the files are still in the i-RAM when you start next day, so there's no need to reload them. I'm a quite satisfied user of i-Ram, although I use it just for the pagefile, most of the time. Read much more about it and details about the exotic media I've mentioned above in this thread elsewhere (posts #38-49... it was sort of a thread hijack, :blushing: as you can see).

Or you could go the ramdisk way: a 256 or even 512 MiB ramdisk could be easily created from your existing RAM, would impact little on the performance of your Vista system and is surely faster than any of the above mentioned hardware, except, perhaps, the Fusion ioDrive.

0

Share this post


Link to post
Share on other sites

I would try a defrag first. As you have the timings already, it is an ideal time to try.

Cheers

Derek

0

Share this post


Link to post
Share on other sites

I would definitely NOT buy one based on the info we have so far.

I opened a 13,746KB file and started a stopwatch. Three minutes and 20 seconds

That suggests the drive is NOT your bottleneck. If it was just loading slow from disk, here you'd be talking about 68 kilobytes per second which beyond ridiculously low -- we had FAR better performance on drives that are over a decade old. Even crappy old floppy drives are faster than that. In fact, I've written a totally trivial C# app that checks how fast I can load a 15MB file (well, whatever file you happen to name file.ext) into a byte array, just to see how long it could really take:


DateTime before = DateTime.Now;
byte[] buff = File.ReadAllBytes("file.ext");
DateTime after = DateTime.Now;
TimeSpan ts = after - before;
Console.WriteLine(ts.TotalMilliseconds);

It doesn't get much simpler than that... The result on a 15MB file (on the first run)? 150ms or so is the absolute max I've seen. Even on a slower drive it wouldn't be much higher than that. So I can't see file I/O accounting for more than perhaps a second or so of that 3 minute 20 second delay, unless there is something wrong with your I/O subsystem at some level (malware? misbehaving driver? security suite slowing disk access a lot? -- although all these would make the computer really sluggish as a whole).

Long story short, buying a SSD may potentially reduce that second or less worth of I/O latency, but as is it won't really help with the rest of that 3 min 20 sec you're waiting.

Something else must be causing this. Such very large office documents tend to be fairly complex, but it's not like it should peg your CPU to 100% for over 3 minutes. Perhaps it's an antivirus (or malware-related app) that's causing the delay. Or office checking if someone else on the network has it open already (this can take forever sometimes). Hard to guess.

0

Share this post


Link to post
Share on other sites

If money is not a problem, you should go for a Fusion ioDrive. If it's somewhat of a problem, a RAID array of 6 class 10 SDHC cards will do nice. But usually both are too expensive as solutions. For normal mortals, A 4 GiB Gigabyte i-Ram is the best solution money can buy. But you'd have to load it the files at the start of a working day and backup them to safer media at the end of the day, just to keep on the safe side. All going well, the files keep there all right, so you just need to backup at the end of the day, each day, to keep safe, but the files are still in the i-RAM when you start next day, so there's no need to reload them. I'm a quite satisfied user of i-Ram, although I use it just for the pagefile, most of the time. Read much more about it and details about the exotic media I've mentioned above in this thread elsewhere (posts #38-49... it was sort of a thread hijack, :blushing: as you can see).

Or you could go the ramdisk way: a 256 or even 512 MiB ramdisk could be easily created from your existing RAM, would impact little on the performance of your Vista system and is surely faster than any of the above mentioned hardware, except, perhaps, the Fusion ioDrive.

dencorso,

You gave me a lot to chew on! :) I'll look into these various possibilities.

Hmm, I haven't used a RAMdisk since the good old days of DOS. I thought the whole concept had died a natural death with the advent of big RAM capacities and OS's able to utilize them. How about that.

--JorgeA

0

Share this post


Link to post
Share on other sites

I would try a defrag first. As you have the timings already, it is an ideal time to try.

Cheers

Derek

Derek,

Thanks for the idea, I hadn't thought of that.

Norton 360 claims that my disk is just 1% fragmented, though, so assuming that N360 is accurate then that shouldn't be the source of the problem. Assuming...

--JorgeA

0

Share this post


Link to post
Share on other sites

The whole thread at Boot-Land I pointed you to is dedicated to just one of the many ramdisks available: Gavotte's... Ramdisks both as a concept and as actual software are alive and kicking. Here's still more to chew on: Ramdisk Benchmarks.

That said, I think CoffeeFiend is right on-the-mark: probably your problem goes well beyond using a fast storage device. The delay you reported seems to indicate a lot of processing going on. You should investigate it further. However, since setting a ramdisk can be done for free, it might help comparing what happens on opening some of these files from your current HDD and from a ramdrive, which is way faster, to establish whether the speed of the storage device actually does bear on it (and if so, how much) or not.

0

Share this post


Link to post
Share on other sites

CoffeeFiend,

Thanks a bunch for the diagnostic.

The thought of malware did cross my mind. However, I regularly run my PC through (1) Norton Internet Security, (2) Windows Defender, (3) Spybot Search & Destroy, and (4) Eset NOD Online Scanner, plus (5) the MS Malware Removal Tool. We know that no single security application is perfect, but it would have to be a heckuva malware program to get past all five of these.

Of these, Norton and Spybot are resident. We can imagine that they'd slow things down, but when nothing else but them is running my CPU Meter hovers between 01% and 25% or thereabouts -- hardly enough to account for the slow loading speed. And Norton hasn't been set to scan Office files as they're opened. When I opened the test file tonight again, CPU usage topped out at about 74%, and more often was bouncing around the 25% mark even as the file was loading.

Regarding a network -- I do have my PCs on a home network, but I don't have a server and file sharing is not enabled on this computer. Still... is there a way to find out whether Word is spending time checking to see if another computer is using the file? If it helps, I notice that for that 501-page file it starts off very slowly, loading some 3 pages at a time like molasses, till it gets to a certain point (near the halfway mark) and then it starts adding pages quickly.

What else could affect load time? Could the number of open IE windows have a bearing on it? (I'm groping for other possible culprits.)

Anyway, it sounds like getting an SSD wouldn't cut down noticeably on file loading time even in the best of cases. (You may have saved me a bundle of dough here, thank you!) So what's all the rage about regarding SSDs?

--JorgeA

0

Share this post


Link to post
Share on other sites

Sounds like it's not malware or virus/spyware/malware-scanner apps then.

is there a way to find out whether Word is spending time checking to see if another computer is using the file?

You can peek at the bottom, it should say so in the status bar.

What else could affect load time?

A network printer perhaps. Lots of them have misbehaving drivers too (I've seen several that made Photoshop crash instantly when creating new documents...) You could try to change your default printer to something else temporarily, just to see if that fixes it.

I would also try to open word in safe mode (using /a) then opening the document (file>open or using its icon) to see if that changes anything. if the delay persists, then we also know it's not due to word itself (the app or related "extensions") loading slow but rather the document loading slowly.

I don't think I've ever come across a word document that was this big though so I'm not totally sure what kind of performance to expect then (depending on the document complexity of course)...

0

Share this post


Link to post
Share on other sites

If all other hypotheses can be safely discounted, then let's go back to the faster storage device idea. I'd say create a Restore Point, then install the Free Version of VSuite Ramdisk. It's the faster one available. Set it to 512 GiB. Then copy your test file to it and do a test. Compare the full load times, an let's see what happens. It doesn't hurt to try. And if it actually solves your problem you might even consider upgrading to the paid version, which is even faster, because it has a Direct I/O mode, although it may not be worth, perhaps, paying for it. I bet the free version will be enough, already. But let's see.

Edit: I overlooked the fact that you use a 64-bit OS. This means you have to use the paid for version of VSuite Ramdisk. However it's 15-day free trial, so you can test it all right. Now, if you want a free Ramdisk, there is the Dataram or the Gavotte. And both are good enough, too. However, the former is easier to set up. Then again, the VSuite is twice as fast, at least, because it can use Direct I/O.

0

Share this post


Link to post
Share on other sites

CoffeeFiend,

O.K., we can rule out a network printer. I'm not using printer sharing on the network.

I'll try opening the file in Safe Mode tomorrow. Late last night I cleaned out the Registry with CCleaner (it removed 113 broken entries), and the load time went down to 2:47. Still not great, but better.

Thanks for the idea.

--JorgeA

0

Share this post


Link to post
Share on other sites

I actually wondered if this was on a clean installed windows but I know now it's not, so, would it be better to reinstall all your software first (please leave Norton out on your fresh install) and see what that does?

0

Share this post


Link to post
Share on other sites

dencorso,

Thanks for the tip. I downloaded the Professional Version trial and installed it, then copied the Word file to it and opened it in Word. Load time was 3:03.

Out of curiosity, I then closed the file, went back into the hard disk, and opened the original copy of the file from there, again in Word. Load time: 3:03. :w00t:

Amazingly, the RAM disk seems to have made, literally, no difference!

--JorgeA

0

Share this post


Link to post
Share on other sites

I actually wondered if this was on a clean installed windows but I know now it's not, so, would it be better to reinstall all your software first (please leave Norton out on your fresh install) and see what that does?

puntoMX,

Hola, ¿qué tal? :hello: Good to hear from you again.

But man, that would be a radical measure!

Would you want to leave Norton out permanently, or only for the duration of the test?

--JorgeA

0

Share this post


Link to post
Share on other sites
Amazingly, the RAM disk seems to have made, literally, no difference!

Let's validate the test first: download Crystal DiskMark and benchmark both your HDD and then the ramdisk (screenshots welcome! :D ). The difference must be huge. If so, then really the bottle-neck is not loading the file, but processing it. It just may be that word really needs all that time to assemble the document from the way it's stored in the file. :}

PuntoMX abominates Symantec Norton products, but he may have a point there. However I see no need for a reinstall, at this point. Tell me, please, how many Symantec products, Norton or Corporate, do you have in your setup, and which products are they.

0

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.