We recently went from datomic pro to datomic cloud. The queries that included where-clauses that worked in pro are not working in cloud due to regex, but even the ones that are pulling all of one entity without any where-clauses are incredibly slow. In pro that query to find all took maybe a second or two. In cloud, the same queries are taking well over a minute–sometimes up to 6 minutes.
Is datomic cloud known to be substantially slower than pro? What can I do to decrease the query time?
Hi @maniginam,
Can you share more specifics on what you are seeing?
How was your Pro System provisioned? Size of instances, caches used, etc?
Do you have query-stats from a query you have identified as “this used to be faster”?
How have you provisioned your Cloud system (size of instances etc)?
Can you provide the same query-stats for the same query run on the Cloud system?
In general, both systems should be very close in performance if properly configured and operated. However, Cloud does introduce a network hop with the client api, but that difference should be minor. And if you used client-pro I would suspect very similar.
If you would like to share specifics, but are not comfortable posting them in our public forum you can send in a support case here: https://support.cognitect.com/hc/en-us/requests/new Or e-mail support@datomic.com
Thanks,
Jaret