Grist vs. SAP Adaptive Server Enterprise (ASE), legacy

This is well suited to someone (or a team) who are technically minded and have a dataset that they need to be able to use in many ways. It's less appropriate for a team who isn't technically minded and/or don't have the data they need to manipulate. It would be useful for things that you could use a database or spreadsheet for such as CRM, Advertising database, Business tracking, Health tracking etc.

Incentivized

High-performance, high-concurrency transactions are well suited for ASE. ASE is lacking some features in my opinion such as history tables, however there are ways to implement them via workarounds or by using Replication Server. I do think the way the ASE parser and optimizer works are far superior to other products as it is a true cost-based optimizer and the order of the tables in the FROM clause does not really matter although a good SQL coder will place the tables in a meaningful order to make the SQL more readable. ASE is good for applications that require high availability and can be used for mission critical systems.

Incentivized

• Provides amazing customer service, help, examples, and explains what they are having you do
• The layout is easy

• Easy to setup and maintain
• Reliable, rarely has major hiccups requiring reboots or crashes
• Very responsive with complicated queries spanning various tablespaces and hundreds of millions of rows

Incentivized

• Making the user permissions more obvious on how to use them - They are highly adaptable, but hard to understand how to use them
• Small changes such as auto colouring the choices/toggles options and being able to edit them once set.
• Being able to copy the formatting from one column to the next

Incentivized

• Full database encryption - need to utilize external keys vs internal - for better separation of duties.
• History Tables.

Incentivized

Our licenses are perpetual. It is the support that we will be renewing. We will renew because we continue to use and receive value from the product.

Incentivized

It does almost everything we need and for the things it doesn't do natively, we are still able to do using other features. For example, natively history tables weren't supported but we were able to create them using triggers.

Incentivized

Incredibly responsive, saving us countless hours in troubleshooting.

Incentivized

Grist is easier to use, faster, and loads quicker with heavy data.

Much less effort than Oracle. Much better customer support than Oracle. Roughly equivalent to SQL Server in performance and ease of use. Much better customer service than SQL Server. Different ballpark from IQ. Same customer service.

Incentivized

• It's saved a lot of time in both creating an advertising database and managing it week to week effectively. I had previously created in others that haven't worked, and this does, saving me a good 1 hour weekly, and 5 hours or more each time I had problems with the last ones
• Being able to stay on track with this has meant I'm following up at the right time (advertisers) and keeping a professional manner and not losing business due to missed communication
• Saving me $ from buying a program like Access (or Airtable monthly) and then the learning curve that that has. This has a much easier learning curve to say the least.

Incentivized

• Negative - Costs a lot ... but so do they all.
• Positive - It does what we need it to do.

Incentivized