-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Thomas, et al --
...and then Thomas Spahni said...
%
% Hi, David
Hi!
%
% On Tue, 21 Jan 2003, David T-G wrote:
%
% > % Are you sure that smallint is enough for your index? Do you really need to
% >
% > I've thought about that a bit, but don't kn
Hi, David
On Tue, 21 Jan 2003, David T-G wrote:
> % Are you sure that smallint is enough for your index? Do you really need to
>
> I've thought about that a bit, but don't know if there is a more 'right'
> answer that comes with experience... In this case and other cases I've
> had so far, it is
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Thomas, et al --
...and then Thomas Spahni said...
%
% On Mon, 20 Jan 2003, David T-G wrote:
%
...
% > create table pieces
% > (
% > # ID number
% > id smallint unsigned not null default 0 auto_increment primary key ,
% > title char(
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Victoria, et al --
...and then Victoria Reznichenko said...
%
% On Monday 20 January 2003 16:16, David T-G wrote:
% > create table pieces
% > (
...
% > words text (4095) ,
% > fulltext index (words(4095))
% > ) ;
%
% David, "words text (
On Monday 20 January 2003 16:16, David T-G wrote:
> create table pieces
> (
> # ID number
> id smallint unsigned not null default 0 auto_increment primary key ,
> title char(50) ,
> index (title) ,
> words text (4095) ,
> fulltext index (words(4095))
> ) ;
David, "words
On Mon, 20 Jan 2003, David T-G wrote:
> OK; here's some code (I didn't want to waste time posting junk, but
> perhaps it's applicable here after all. Thanks for the couple of
> responses so far!
>
> # a particular piece
> create table pieces
> (
> # ID number
> id smallint unsigned
