Subject | Re: Improve read speed on a database intensively written |
---|---|
Author | Sean |
Post date | 2007-06-19T15:10:36Z |
--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@...> wrote:
online resource (if there is any) that I can refer for the implementation?
Thank you!
Sean
<aharrison@...> wrote:
>Right, replication is what I want. Can you please direct me to some
> > 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
>
online resource (if there is any) that I can refer for the implementation?
Thank you!
Sean