Hi,

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
database.

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

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

Thanks a lot!
Sean