Is Full Text-search via Prisma better than ElasticSearch ?

keeping elasticsearch in sync with your DB is a real headache imo

@Mischa hmmmm....so this is the scenario I'm in, the DB holds all transactions state, then there's a service to ensure all pending transactions or transaction that stopped due to any point of failure are retried, basically refetched and repushed. Due to constant read of the database , it increases the cost. That's why I'm considering ElasticSearch.

what DB are you using? are you paying by the IOPS?

@Mischa AWS RDS....yes the more reads the more the cost

might be simpler to use elasticache w/redis and invalidate the cache when there is some failure

@Mischa hmm, never heard of Elasticache. Thanks