On Tue, May 13, 2003 at 12:32:14PM -0700, Michael A Nachbaur wrote:
>
> I tried rserv with a database that has over 1000 inserts per minute, and it
> would just sit there for days at the "Preparing snapshot" (on a
> Dual-Xeon/2GHz). I hadn't tried indexing the id column though.
You not only need an index on it; you need a unique index on it. (If
you have duplicates, replication breaks.)
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew@libertyrms.info> M2P 2A8
+1 416 646 3304 x110