ParAccel - Great software, but deal with its shortcomings
July 19, 2016
ParAccel - Great software, but deal with its shortcomings
Score 6 out of 10
Vetted Review
Verified User
Overall Satisfaction with ParAccel
I used it in MicroStrategy Cloud. It is used as one of the big data solutions provider for all the performance tier customers. Apart from MicroStrategy Cloud, it was also used with MicroStrategy wisdom and MicroStrategy Social softwares. It definitely solved the slower queries that were pestering in SQL Server and Oracle. It is the best in loading the data into the database.
- Data loading is excellent
- ParAccel support is the best I have seen so far.
- Some of the bugs were annoying and QA definitely needs improvement
- Connectivity to Informatica and ETL providers
- Workload management could be better like when you compare with Teradata
- Faster reports
- Faster ETL
- Bugs were annoying and [it was] tough to get the resolution sooner
My comparison with Vertica: ParAccel stays at top because we do not know the projections ahead of time (which is a major performance tuning technique in Vertica)
My comparison with Netezza/Teradata: Definitely, ParAccel is economical, but if you can afford it, go for other providers as they are stable.
My comparison with Netezza/Teradata: Definitely, ParAccel is economical, but if you can afford it, go for other providers as they are stable.
Using ParAccel
- Speed
- Columnar structure
- Compression
- Columnar storage
- Compression to 10:1 ratio
- Backup and restore
- Workload management
Evaluating ParAccel and Competitors
- Price
- Product Features
- Product Usability
- Prior Experience with the Product
I would have reviewed workload management more, especially managing the number of concurrent heavy and lighter queries.
ParAccel Implementation
- Implemented in-house
- Professional services company
- Getting OS configuration right
- Less documentation made the setup tough
ParAccel Support
| Pros | Cons |
|---|---|
Quick Resolution Good followup Knowledgeable team Problems get solved Kept well informed No escalation required Immediate help available Support cares about my success Quick Initial Response | None |
Yes - Yes, a hot fix was deployed very fast just to address my bug. Very impressive!!!
For the leader failover setup, a particular version of Corosync was giving an issue. Support directly jumped in and solved it for me.
Using ParAccel
| Pros | Cons |
|---|---|
Like to use Consistent Feel confident using | Requires technical support Cumbersome Lots to learn |
- Table creation
- Understanding columnar nature of storage
- Backup
- Incremental restore
- Data Compression
- Workload management