Subject Re: Improve read speed on a database intensively written
Author Sean
--- In, "Ann W. Harrison"
<aharrison@...> wrote:
> > 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

Right, replication is what I want. Can you please direct me to some
online resource (if there is any) that I can refer for the implementation?

Thank you!