Mailing-List: contact couchdb-user-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: couchdb-user@incubator.apache.org
Received-SPF: pass (athena.apache.org: domain of sho.fukamachi@gmail.com
 designates 74.125.46.158 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:from:to:in-reply-to:content-type:mime-version:subject
         :date:references:x-mailer;
        b=v+uyNzPSxTczI5Ne9UVayc6lHnq0f5mddyVT5CeWHmVryQj6vTUp6rgWnSnnAwJasf
         ZMR+VLVI3zBsJ1dTUqcKeIFuMtW8UC/4q8ae7amu7ft4KWE2qskUqfRQamvLaxoQkhD4
         qetErz+IFtArH4+THNPWD7g8uAqcImfsyypFE=
Message-Id: <3F8F49C2-EC5C-4E6D-AFC9-854C42F7FC6D@gmail.com>
From: Sho Fukamachi <sho.fukamachi@gmail.com>
To: couchdb-user@incubator.apache.org
In-Reply-To: <0EEE59DA-C752-43E0-A605-31865F6E020F@apache.org>
Content-Type: multipart/signed; boundary=Apple-Mail-169-69290994; micalg=sha1;
 protocol="application/pkcs7-signature"
Mime-Version: 1.0 (Apple Message framework v926)
Subject: Re: when to use another document and when not to?
Date: Wed, 23 Jul 2008 03:19:35 +1000
References: <6b6419750807141546q63431cfek69184295a1cb25b0@mail.gmail.com>
 <64a10fff0807141604i6f4c5778meba60a1f634f518b@mail.gmail.com>
 <4E5620A8-7ACD-4ADB-8FFD-424EEA289E21@apache.org>
 <6b6419750807141654x5b548706i1290367ca84acd27@mail.gmail.com>
 <66471514-BF70-4EFC-A258-CEC5C4799924@gmail.com>
 <e282921e0807200647o45ea98ddt5420fd1180a6149d@mail.gmail.com>
 <DB9384FB-25ED-42F5-B4BA-FA1B1B2CFD60@gmail.com>
 <0EEE59DA-C752-43E0-A605-31865F6E020F@apache.org>

--Apple-Mail-169-69290994
Content-Type: text/plain;
	charset=US-ASCII;
	format=flowed;
	delsp=yes
Content-Transfer-Encoding: 7bit


On 23/07/2008, at 2:33 AM, Jan Lehnardt wrote:
>> The outcome of the previous discussion on this thread seemed to be  
>> in favour of the use of a "followers" table which I thought was a  
>> pretty bad idea in CouchDB. I'd love to hear some defences of that,  
>> maybe someone can tell me what I'm missing...
>
> Your gut feeling was correct, it is a bad idea.

Jan! I'd been hoping you'd comment.

Care to elaborate a bit? I would really appreciate your insight!

The simple situation is this: users can subscribe to other users. We  
need to be able to query in both directions - ie, starting with a  
known user, get the user records he is subscribed to - and the other  
direction, starting with a user, get the user records of those  
subscribed to him.

I had actually been bending to the "followers" table a little, after  
doing some benchmarks and finding that 99% of the time just  
individually GET-ing the list of users (in either direction) from a  
list of IDs obtained from the followers table was going to be fast  
enough.

I would *like* to place subscriptions in one or the other but just  
cannot think of how it is possible to write the views *in both  
directions* once it's stuck in a user, and I end up having to do the  
GET loop anyway.

Would love to hear your views : ) Please let me know if I am not  
making any sense.

Sho

PS sorry all those who are sick of this thread ....


> Cheers
> Jan
> --


--Apple-Mail-169-69290994
Content-Disposition: attachment;
	filename=smime.p7s
Content-Type: application/pkcs7-signature;
	name=smime.p7s
Content-Transfer-Encoding: base64

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIGLzCCAugw
ggJRoAMCAQICEBSIX9MtV1ZEa0RApBcv2rAwDQYJKoZIhvcNAQEFBQAwYjELMAkGA1UEBhMCWkEx
JTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQ
ZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA3MTExODIzMTczNloXDTA4MTExNzIzMTcz
NlowSTEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEmMCQGCSqGSIb3DQEJARYXc2hv
LmZ1a2FtYWNoaUBnbWFpbC5jb20wggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQC4VztI
LAmaS1WLCldsyC8eTG9bLMGvYEwRoJXYnyqJZPXMhQHdzAbw3VTtiqZB8qaWs2QbU/UuioP0zL0N
NAdCVHOORhGq59/u7obOxZOkR94yRllz5ofwpbOfTpC2u0Q6sms9ViukqumPuix2XTs3coe2VPAX
lPFzyQlNOXRD0K7JLUxff3YfM1sIZTHEosNVQWIWtyw+3Hb6ZhpGLuaxqe8jYKSJ+RnE1cX0/lI8
btdT7PyNapyz8m/sGEeMf/a+O+aDRr/cv50GVQWD98CM3a1tvUob3v9iH7L/wFEGyR4V7NLuhbYr
6sqktCzICnjkrCblAIpZnWWBPbvzuJZtAgMBAAGjNDAyMCIGA1UdEQQbMBmBF3Noby5mdWthbWFj
aGlAZ21haWwuY29tMAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcNAQEFBQADgYEATlDmSJ8egBeeoqwO
HCxUloxGqK+hbn7EVNv21XBa0p3l8qHMoVY4IG5Uo3PmmfbtICWw9akuo1kRbhalcwLJK0Cxb32W
Vs0hQMyBrlpHIJJHDfuQ5A1WHW7An20Qdp2CU8WV03TbjdrJw0K7DvwZo6FX65fMiqdDhswP0NTA
HfEwggM/MIICqKADAgECAgENMA0GCSqGSIb3DQEBBQUAMIHRMQswCQYDVQQGEwJaQTEVMBMGA1UE
CBMMV2VzdGVybiBDYXBlMRIwEAYDVQQHEwlDYXBlIFRvd24xGjAYBgNVBAoTEVRoYXd0ZSBDb25z
dWx0aW5nMSgwJgYDVQQLEx9DZXJ0aWZpY2F0aW9uIFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQD
ExtUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgQ0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZy
ZWVtYWlsQHRoYXd0ZS5jb20wHhcNMDMwNzE3MDAwMDAwWhcNMTMwNzE2MjM1OTU5WjBiMQswCQYD
VQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMj
VGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0EwgZ8wDQYJKoZIhvcNAQEBBQADgY0A
MIGJAoGBAMSmPFVzVftOucqZWh5owHUEcJ3f6f+jHuy9zfVb8hp2vX8MOmHyv1HOAdTlUAow1wJj
WiyJFXCO3cnwK4Vaqj9xVsuvPAsH5/EfkTYkKhPPK9Xzgnc9A74r/rsYPge/QIACZNenprufZdHF
KlSFD0gEf6e20TxhBEAeZBlyYLf7AgMBAAGjgZQwgZEwEgYDVR0TAQH/BAgwBgEB/wIBADBDBgNV
HR8EPDA6MDigNqA0hjJodHRwOi8vY3JsLnRoYXd0ZS5jb20vVGhhd3RlUGVyc29uYWxGcmVlbWFp
bENBLmNybDALBgNVHQ8EBAMCAQYwKQYDVR0RBCIwIKQeMBwxGjAYBgNVBAMTEVByaXZhdGVMYWJl
bDItMTM4MA0GCSqGSIb3DQEBBQUAA4GBAEiM0VCD6gsuzA2jZqxnD3+vrL7CF6FDlpSdf0whuPg2
H6otnzYvwPQcUCCTcDz9reFhYsPZOhl+hLGZGwDFGguCdJ4lUJRix9sncVcljd2pnDmOjCBPZV+V
2vf3h9bGCE6u9uo05RAaWzVNd+NWIXiC3CEZNd4ksdMdRv9dX2VPMYIDEDCCAwwCAQEwdjBiMQsw
CQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UE
AxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEBSIX9MtV1ZEa0RApBcv2rAw
CQYFKw4DAhoFAKCCAW8wGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcN
MDgwNzIyMTcxOTM2WjAjBgkqhkiG9w0BCQQxFgQU4CfHDmguUQx5A3IeBMBwL0rvvbkwgYUGCSsG
AQQBgjcQBDF4MHYwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQ
dHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBAhAU
iF/TLVdWRGtEQKQXL9qwMIGHBgsqhkiG9w0BCRACCzF4oHYwYjELMAkGA1UEBhMCWkExJTAjBgNV
BAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25h
bCBGcmVlbWFpbCBJc3N1aW5nIENBAhAUiF/TLVdWRGtEQKQXL9qwMA0GCSqGSIb3DQEBAQUABIIB
AGl1/cH8aOIZiATOA++qJxJwudAolm1t/6CeDxpLssUAnfOTNGoAk/N/gAAlqybWVf37oG9AMyMo
3yA+5t8g172J+QmNQ9QNxDZfjNbD4ghekHDUv1V5IKLNvjtnBygrmlTDJG1WigJTxY1+gYX1Nae7
X3/ate1rmJHMYCdkPndn8fYwwnOt0V/82NLDf0QRcj9I3TTPtEsW4AvmbKWgvN3CaY/1GHFca1Lt
EEstHWvdldIjKK/tD981NU09ntLJX3o4mlgnwGt81W5mKDAZVwFpCRooJPR0N2jmsvECabdV0Zu4
MYCvPJeTmzRmna80mrav39mPfu3pkY42BBYG/ucAAAAAAAA=

--Apple-Mail-169-69290994--