Hi!
On Sep 13, Doug Poland wrote:
One question per line, please !
> Problems is knowning how many columns can be indexed in a table.
max 16 columns per index.
max 32 indexes per table.
so 16*32=512 columns can be indexed in a table, which is less then
max 3398 columns per table.
> Is that num
On Thu, Sep 13, 2001 at 02:17:51PM +0200, Sergei Golubchik wrote:
> On Sep 07, Doug Poland wrote:
> > On Fri, Sep 07, 2001 at 10:41:33AM -0500, Ed Carp wrote:
> > > Lorang Jacques ([EMAIL PROTECTED]) writes:
> > >
> > > > Now I was wondering if it would get faster by using FULLTEXTSEARCH on my
>
Hi!
On Sep 07, Doug Poland wrote:
> On Fri, Sep 07, 2001 at 10:41:33AM -0500, Ed Carp wrote:
> > Lorang Jacques ([EMAIL PROTECTED]) writes:
> >
> > > Now I was wondering if it would get faster by using FULLTEXTSEARCH on my
> > > tables. As it is quiet some work, I first want to ask you guys if t
On Fri, Sep 07, 2001 at 11:10:46AM -0500, Ed Carp wrote:
> > Do the current limitations of 500 characters per index and limited (?)
> > number of columns per index pose problems? I want to use fulltext
> > on a database with 7 varchar(255) columns and several smaller varchar
> > columns but can't
> Do the current limitations of 500 characters per index and limited (?)
> number of columns per index pose problems? I want to use fulltext
> on a database with 7 varchar(255) columns and several smaller varchar
> columns but can't build a fulltext index. Is there documentation on
> the limitat
On Fri, Sep 07, 2001 at 10:41:33AM -0500, Ed Carp wrote:
> Lorang Jacques ([EMAIL PROTECTED]) writes:
>
> > Now I was wondering if it would get faster by using FULLTEXTSEARCH on my
> > tables. As it is quiet some work, I first want to ask you guys if this
> > is really going to make my queries f
Lorang Jacques ([EMAIL PROTECTED]) writes:
> Now I was wondering if it would get faster by using FULLTEXTSEARCH on my
> tables. As it
> is quiet some work, I first want to ask you guys if this is really going to
> make my queries faster (much faster ?)
Yup. I've got the entire set of laws for th
Hello,
Actually I am programming an web directory (like yahoo). But my sql queries
need
ernormous cpu resources. So it is quiet slow. I can't use indexing because
my serach works with <>. (apparently then it dosen't
help).
Now I was wondering if it would get faster by using FULLTEXTSEARCH on my
t
