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
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 this
is
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
tables. As
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 LIKE '%$serchstring%'. (apparently then it dosen't
help).
Now I was wondering if it would get faster by using
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 the
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 faster
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 limitations
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 build