SSD in corporate desktops?

Associate
Joined
5 Nov 2002
Posts
2,152
Location
Melbourne
Would be interested in thoughts on the use in a SSD in a desktop? It seems until a 64bit OS is common place in large corporate we are at bottle neck, i.e we currently run Quad Xeon i7 with 4gb ram on XP32bit for some traders & find that PC's still grind to a halt. Excel (2007) seems to be the main culprit with some files >50mb pulling data in from Reuters & bloombergs etc.

I am wondering if a SSD would show a significant improvement to performance? Or does anyone in a large corporate run a 64bit OS as standard for users?
 
From your description it doesn't sound like the issue is disk access on the desktop.

Whilst it would help with Excel load speed itself it won't make accessing the storage of location of the file quicker, or getting the info from Reuters / Bloomberg etc.

Or is the problem the time it takes for Excel to load.
 
I'd agree with mdjmcnally.

It sounds like you need to look at those spreadsheets and do some performance tweaking, with 4Gb of ram and that beast of a cpu you should be operating nearly entirely in memory so an SSD won't make much difference.

Excel is a clunky old beast (I suspect it's still got 16-bit code in it, even with 2007's improved row-count).

akakjs
 
Opening and parsing large files has been and probably always will be, a relatively time consuming process.

An excel 2007 file will be (I assume) in the new XML based format, and at 50mb will contain a lot of data. As has been said, the 50mb will be loaded into memory almost instantly, probably aorund a second with a good hard drive. However Excel then has to parse all the data, this is what takes the time.

Unfortunately Excel doesn't yet make good use of multiple cores nor is it particularly fast to parse its files.

The problem lies with Excel and not your PCs in this case I fear.

EDIT: Also, a 64 bit OS will, in most scenarios, reap no performance difference. If you think logically about how a 64 bit OS differs from a 32 bit OS, it is not in HOW it processes data, just that it can address more memory locations at once. The primary advantage of a 64 bit OS is simply that of being able to recognise and physically utilise more memory. For memory hungry applications this is very useful, however for many commercial apps, they are all still 32 bit, so even when run in a 64 bit environment, they will have a 2-3GB memory limit anyway (depending on how it was compiled). Having said that, if you have 4GB of RAM in a machine, it make no sense to have a 32 bit OS when it can be avoided, purely because from the end users point of view it will make no difference and it will give them access to a further .75GB of RAM.
 
Last edited:
Ta guys...i aware that the problem is mainly caused by Excel. But having never seen an SSD in action I would be interested to know if it did help with performance.

What crazy is our previous build with office 2002 on it run all these spreadsheets much quicker.
 
Dont generally see many SSD's in corp desktops - starting to get them in SAN's now though, especially performance ones. Theres a company called RAMSAN who are specialists in it. Very fast but very $.
 
Excel is dire for this sort of thing. Suggest you get some applications guys looking at your problem rather than forking out for new hardware.

Of course,one of the problems you may have in excel is it's doing calculations which you don't really want to see.

Consider you have three sheets in a workbook, one calculation on each, and then a sheet full of data. You can only look at one sheet at any point in time, so it makes no sense to calculate the other two sheets.
 
We have traders in much the same scenario, mainly on C2D's with 4GB using XP Pro (32 bit)

We have seperate pc's for those who need Reuters and Bloomberg, and certainly we have a lot of Excel 2003 spreadsheets (mainly bbg based) and they can be a pain in the ***

Over time it seems as though the files themselves just get bogged down, and its a fiddle to re-create them from scratch, but I know one or two analysts and traders who do this routinely every so often because it ends up saving them time in the long run.

Excel is dire for this sort of thing. Suggest you get some applications guys looking at your problem rather than forking out for new hardware.

Of course,one of the problems you may have in excel is it's doing calculations which you don't really want to see.

Consider you have three sheets in a workbook, one calculation on each, and then a sheet full of data. You can only look at one sheet at any point in time, so it makes no sense to calculate the other two sheets.

I totally understand where you are coming from but this actually isnt true at all.

a lot of the guys (and gals) here have really complex grids / excel sheets of data coming in from different parts of Bloomberg, and while they only see the results on the front page, these actually rely on complex equations going on in the background on other sheets after the bbg data has been processed and analysed (ie they arent necessarily interested in just the basic bbg info)

Probably poorly explained but it does actually make sense that the other calculations HAVE to be completed before the front sheet is displayed
 
Last edited:
Out of interest - are there some calculations that can be done centrally, before the spreadsheet displays the results of some less complex calculations.

I can't believe that someone would not have written some software for this.. especially in an environment where time is money etc.
 
Out of interest - are there some calculations that can be done centrally, before the spreadsheet displays the results of some less complex calculations.

I can't believe that someone would not have written some software for this.. especially in an environment where time is money etc.

I guess thats more like a database, and harder to program for the average user than an excel file (or maybe Im just mis-understanding what you mean) ;)
 
I would suggest trying to benchmark the various stages in opening the file:

Buy 1 SSD and install it it one machine. Then for a 'normal' desktop and the SSD desktop:

1) Copy the file to local disk - time it over say 10 copies take average
2) Open file from local storage - reboot each time to prevent caching - 10 times, take average

See which is faster - is the upgrade worth it ?

Total cost about £300 plus your time. Not much for a trading environment.
 
Out of interest why are your traders using Excel and not products like R, S+, SAS, Stata, SPSS, MATLAB for heavy numerical work. Are they a bit retarded? I wouldn't for a second think Excel would be even remotely compariable performance wise to R for doing almost anything like supporting trading.
 
Chucked an SSD in the MDs laptop this week. He was loving the 10 second reboots. I think we're all getting one now ;)
 
Out of interest why are your traders using Excel and not products like R, S+, SAS, Stata, SPSS, MATLAB for heavy numerical work. Are they a bit retarded? I wouldn't for a second think Excel would be even remotely compariable performance wise to R for doing almost anything like supporting trading.

Yes they are retards & descend from Joey Deacon :rolleyes:
 
Back
Top Bottom