🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: ʹ��alter table�����е�����

#465
From: 6/17
Date: Wed, 08 Apr 2009 07:11
23 lines
1861 bytes
Ŷ�����������˵��enforce FKԼ��ɣ�����MyISAMһ��
��֮ǰ��Ϊ��˵����FK������normalization

����group by֮��Ļ������ǵ��Լ�ά��index��

�� �� Boykins (���-���}�˹����ɽ��ˮ��}������) �Ĵ������ᵽ: ��
: һЩOLTP��վ���᲻��FK��
: FK��4��ȱ���ǣ�
: 1.����ϵͳ����
: 2.ά���ĸ�����
: ��ʵûʲôtrick��application�˻Ḻ���������������߼���
: ���ϣ��ܲ�����ݿ���ɵ����񣬾�����������~
: ����order by����group by֮����Ҫ����ľ���app��
: ��Ϊdatabase����backend����Դ����critical��
: ��������Ҫ�������ǵ�database����
: �� �� Programmer �Ĵ������ᵽ: ��
: .................������ʡ�ԣ�

--
Two bytes meet.  The first byte asks, "Are you ill?"
The second byte replies, "No, just feeling a bit off."

�� 4Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 149.171.237.17]
Technical Details
Message-ID: <4fKi4j$bGc@bbs.sjtu.edu.cn>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!news.neu.edu.cn!news.shec6.edu.cn!SJTU

Show Full Headers
Complete Article Headers
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!news.neu.edu.cn!news.shec6.edu.cn!SJTU
From: Programmer.bbs@bbs.sjtu.edu.cn (6/17)
Newsgroups: cn.bbs.comp.database
Subject: Re: ʹ��alter table�����е�����
Date: 08 Apr 2009 07:11:11 GMT
Organization: ��ˮ˼Դ
Message-ID: <4fKi4j$bGc@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1239174381.A
Lines: 22