|Subject||Re: [firebird-support] Improve read speed on a database intensively written|
|Author||Ann W. Harrison|
> Hi,Another option is to replicate and read from the replicant.
> 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