Differences From:

File src/schema.c part of check-in [eea381f416] - Progress toward delta compression on the xfer protocol. The compression works well. But the client is not telling the server what files it has so the server does not have anything to delta against. by drh on 2007-08-09 03:19:18. [view]

To:

File src/schema.c part of check-in [73bddaebb9] - The delta compress on xfer is working better now, but still needs work. by drh on 2007-08-09 17:42:59. [view]

@@ -136,8 +136,10 @@
 @   fnid INTEGER REFERENCES filename    -- Name of the file
 @ );
 @ CREATE INDEX mlink_i1 ON mlink(mid);
 @ CREATE INDEX mlink_i2 ON mlink(fnid);
+@ CREATE INDEX mlink_i3 ON mlink(fid);
+@ CREATE INDEX mlink_i4 ON mlink(pid);
 @
 @ -- Parent/child linkages
 @ --
 @ CREATE TABLE plink(
@@ -161,11 +163,13 @@
 @ );
 @ CREATE INDEX event_i1 ON event(mtime);
 @ CREATE INDEX event_i2 ON event(objid);
 @
-@ -- Make sure reading DELTA by SRCID is efficient
+@ -- A record of phantoms
 @ --
-@ CREATE INDEX IF NOT EXISTS delta_srcid ON delta(srcid, rid);
+@ CREATE TABLE phantom(
+@   rid INTEGER PRIMARY KEY         -- Record ID of the phantom
+@ );
 @
 @ -- Aggregated ticket information
 @ --
 @ CREATE TABLE tkt(