Sean wrote:

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

Another option is to replicate and read from the replicant.

Cheers,


Ann