Hi all,
We're busy working away on our new SaaS, Lumetric, but in the meantime we made a big update to FunnelFlux -- replacing the analytics database we use with the one we're using for the SaaS.
The results are pretty awesome, and we have also significantly reduced our pricing for the Managed Version as a result. In many reports our new DB is 5000% faster!
Our basic managed stacks can now handle a lot more volume -- so if you are doing very high volume and looking for the most cost-effective solution, you might want to revist our Managed Version (note it's not a SaaS, but it can still kick ass at scale).
How has our pricing changed? Our new entry-level managed offering is only $139/mo (it used to be $179/mo). That's now almost the same cost as our self-hosted ($99/mo) license + your own basic server costs.
For those of you who are existing customers, or past customers who may have ran into some performance issues (we are aware that MySQL + our old background jobs caused a lot of annoying situations), check out my update details below!
As always you can use your STM credit to get $100 off your first month -- just visit https://www.funnelflux.com/partner/stm/
If you have any questions ping us at support@funnelflux.com.
...and if you're interested in the SaaS, we are now letting testers in -- sign up at test.lumetric.io to get your hands on. We will be giving up to 6 months free at launch for anyone who provides us with video feedback 
========================================
Summary of improvements
No more background jobs
These were used to cache reports on common attributes to make reporting faster, since MySQL is quite slow for the typical reports we run. However, it often lead to a lot of background resource usage and error that caused stats to get stuck. These are gone! Now, reports all pull directly from the database.
Faster complex reports
Before, we had to use background jobs to precalculate reports. But when you did complex reports, like grouping down to hit ID, conversion IDs, conversion paths and URL tracking fields, if you had a lot of data it could get very slow. Clickhouse excels here -- check out this testing I did to compare, which is across a data set of 1 million visitors:

For simple reports there is not much difference (because before they were pre-cached anyway). But check out the difference when running a report like Campaign > Funnel > Traffic Source > Country > Device Type > URL Tracking Fields > Referrer. The key here is having things like tracking fields where they could be 100's of values, and then 100's of referrers inside these.
Before?
MySQL took about 2 minutes to run this report.
The new DB?
2.4 seconds. Yep, about 50x faster! So, you should find much better performance overall, with all kinds of reports.
Better handling of parallel activity
Before, if you were running a report, you couldn't browse the rest of the app as the DB was busy.
The new DB handles parallel tasks very well. As a result, the system is also much better at doing cost and conversion updates, at the same time as you are running hefty reports and using the API to do updates.
We did testing and found the system did not slow down or get backlogged when hitting it with 50 visitors/sec, while also running parallel cost and conversion updates on the data, as well as stat resets. No problemo, happy times
Better compression
The new DB is highly compressed, so for the same amount of visitors, you will use significantly less disk space.
Resetting stats actually frees up space
Before, we had the annoyance of a MySQL limitation -- when you reset stats and delete data, it removes it from the database but does not release file space back to the OS. So if your disk hit 90% usage, there was no easy way to free space up.
The new DB doesn't do this, so its much easier to manage removal of data if you have too much.
Reduced cost of managed plans!
This is a result of the new DB, but deserving of its own section.
Because of these improvements, we are able to significantly reduce the cost of Managed FunnelFlux for this new version.
The Managed FunnelFlux servers can also handle more visitors, and store more data long term.
So, our new plans using Clickhouse will have the following details:
-- Flux Micro $139/mo (was $179), 80 GB of storage, suitable for 20 M visitors per month.
-- Flux Starter $179/mo (was $249), 160 GB storage, suitable for 30+ M visitors per month
-- Flux Pro $249/mo (was $449), 320 GB storage, suitable for 50+ M visitors per month
-- Additional servers -- we're dropping the price of this to $50/mo per server, so we can put servers in the US, Europe, Asia etc. for you at lower cost, to improve redirect speeds. This requires Cloudflare usage.
All new managed customers will receive this new pricing.
If you are an existing managed customer and want to migrate, feel free to reach out -- we will begin offering this soon, but keep in mind what I mentioned in the previous email -- you will be able to migrate funnels and config, but not old stats.
If you are a self-hosted customer, don't fret! We will be releasing a Clickhouse-based version soon, and you will all be able to upgrade to it at your discretion, or ask us to help you migrate.
Again, you won't be able to migrate old stats, but the benefits may certainly be worth it.
Reach out to us if you would like to move on to FunnelFlux V2. We'll send reminders in the future and keep you updated on when the self-hosted version releases.
========================================
Thanks as always STM!
-Zeno
Wow, this is a nice speed improvement.
Recently I checked the FF website again after long time and I realized that there are some very cool features that I didn´t see anywhere else.
Now I think about testing FF on a second server a bit to see how it goes.
I personally love all advanced yet easy to use features FunnelFlux has, especially the flexibility it has when generating drill-down reports.
This update should have improved report generation time to just milliseconds!