Subject Improve read speed on a database intensively written
Author Sean

I found that the speed of queries can be very slow when the database
is intensively updated/inserted. To maintain reasonable UI response
that heavily depends on query speed, I am thinking to split the
database into two, one for update, one for query. Then periodically,
e.g. every minute, sync the changes from updated database to query

1. Is this a good idea? Or are there other options?

2. Can someone please suggest on how to do it?

Thanks a lot!