Subject Re: [firebird-support] Improve read speed on a database intensively written
Author Ann W. Harrison
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.