🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: cn.bbs.comp.database
Article #146

Re: �ж�key-value��ݿ���Ϥ�����ʸ�����

#146
From: ���ۣ�˲�ţ���;���������
Date: Tue, 22 Nov 2011 00:57
20 lines
2188 bytes
������
�� �� majiayige (���һ��) �Ĵ������ᵽ: ��
: һЩkey/value��nosql��ݿ�֧����ϼ���ʵ���������composite index�����Щ����
: ���磬������һ��index(a, b, c)����IJ�ѯ�����������a����(a, b)����(a, b, c)��
: ������õ����index���������IJ�ѯֻ��(b, c)�������������ò����ˣ�ֻ��full 
: table scan��
: ����Ǹ���a==x && b>y����ѯ�������ǿ����õ���a, b)�ϵ�����ģ��������ֻ��ѯb>
: y����û�취�õ���������ˡ�
: ps. ���Dz������ڷ�...
: �� �� IPfrog �Ĵ������ᵽ: ��
: : ��֪������key-value����ݿ�ֻ�����key���в��ҡ�
: : ��Ϊ��key-valude��ݿ�һֱ��̫��Ϥ����������̣�
: .................������ʡ�ԣ�

--
����һ���˵��ó�! 

ISForever

�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 180.168.8.166]
Technical Details
Message-ID: <5917NZ$aqj@bbs.sjtu.edu.cn>
Path: arc1-ca.pugleaf.net!lh20ni12749pbb.0!nntp.google.com!news1.google.com!news.glorb.com!feeder.erje.net!news.byr.edu.cn!news.shec6.edu.cn!SJTU

Show Full Headers
Complete Article Headers
X-Google-Thread: 101948,4a360250ff19d9cc,start
X-Google-NewGroupId: yes
X-Google-Attributes: gid4df683fd51,domainid0,public,usenet
X-Google-Language: Chinese,GB
Received: by 10.68.35.68 with SMTP id f4mr8003770pbj.5.1322138884256;
        Thu, 24 Nov 2011 04:48:04 -0800 (PST)
Path: arc1-ca.pugleaf.net!lh20ni12749pbb.0!nntp.google.com!news1.google.com!news.glorb.com!feeder.erje.net!news.byr.edu.cn!news.shec6.edu.cn!SJTU
From: ISForever.bbs@bbs.sjtu.edu.cn (���ۣ�˲�ţ���;���������)
Newsgroups: cn.bbs.comp.database
Subject: Re: �ж�key-value��ݿ���Ϥ�����ʸ�����
Date: 22 Nov 2011 00:57:30 GMT
Organization: ��ˮ˼Դ
Message-ID: <5917NZ$aqj@bbs.sjtu.edu.cn>
Mime-Version: 1.0
X-Filename: database/M.1321923443.A
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit