I was reading this http://www.theregister.co.uk/2011/08/23 ... es_violin/ and was wondering is anyone has tried or thoughts on what TM1 would run like if it was using FLASH for swap space in a constrained RAM environment?
If you were working at the extreme end of size in the 64 bit world I was wondering if it would be useful or FLASH is still so much slower than RAM that it wouldn't be worth it?
Cheers,
Steve
Running TM1 in FLASH memory
-
Steve Rowe
- Site Admin
- Posts: 2464
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Running TM1 in FLASH memory
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
jim wood
- Site Admin
- Posts: 3961
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Running TM1 in FLASH memory
Interesting idea. I suppose you could do it quite cheaply as well. All you would need is a 64GB drive. Install it and make sure all swap space is addressed on that drive...
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
tomok
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Running TM1 in FLASH memory
Sounds good in theory but, unless you are taking about a desktop or laptop PC, I think you will find that hard drive response times on servers to be really good these days, not that much under the performance of a flash drive. i don't see a lot of potential here but I could be wrong.
-
jim wood
- Site Admin
- Posts: 3961
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Running TM1 in FLASH memory
It's good point. I'm not sure how they would line up against against a scsi drive. One thing to keep in mind, their over all performance is based on both read and write. Reading data from flash drives is far quicker than any other hard drive.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
John Hammond
- Community Contributor
- Posts: 300
- Joined: Mon Mar 23, 2009 10:50 am
- OLAP Product: PAW/PAX 2.0.72 Perspectives
- Version: TM1 Server 11.8.003
- Excel Version: 365 and 2016
- Location: South London
Re: Running TM1 in FLASH memory
Depending on the age of your RAM and FLASH, FLASH is 50-1000 times slower than RAM so it's not going to replace RAM on your machine. As mentioned in earlier discussions once you drop out of RAM you lose a lot of the benefits of MOLAP so use of virtual memory is never desirable in TM1. That said it is much faster than HDD if you have to use VM.