All,
- Original Message -
From: "mos" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Sunday, January 30, 2005 6:29 AM
Subject: Re: FULLTEXT index on InnoDB tables (looking for a workaround)
At 02:32 PM 1/28/2005, you wrote:
And, of course, another opti
At 02:32 PM 1/28/2005, you wrote:
And, of course, another option is to contact Heikki and coax him into
hiring somebody to add FULLTEXT to InnoDB tables.
And bring lots of cash with you. :-) I've pestered Heikki a couple of years
ago and he's willing to do it only if there is someone willing to f
symbulos partners wrote:
Thanks for the extremely useful answer.
Some comments, questions here below.
On Friday 28 Jan 2005 16:38, you wrote:
No, only the BLOB/TEXT columns need to be moved to MyISAM.
Yes, I thought of doing so. The drawback is that you de-normalise the
database. Is that correct?
symbulos partners wrote:
Is there any other workaround? The reason because we are using InnoDB is
because there s full support
- for foreign keys,
- for joint queries
- for rollback on commit
Does anybody know any other way of indexing the table in a way, which would
allow full text search?
Thanks for the extremely useful answer.
Some comments, questions here below.
On Friday 28 Jan 2005 16:38, you wrote:
> No, only the BLOB/TEXT columns need to be moved to MyISAM.
Yes, I thought of doing so. The drawback is that you de-normalise the
database. Is that correct?
There are 2 alterna
Thanks for the extremely useful answer.
Some comments, questions here below.
On Friday 28 Jan 2005 16:38, you wrote:
> No, only the BLOB/TEXT columns need to be moved to MyISAM.
Yes, I thought of doing so. The drawback is that you de-normalise the
database. Is that correct?
There are 2 alterna
> > > As you have noticed - you cannot.
> > >
> > > So, all you can do is creating a MyISAM table and copying
> > > the column contents.
> >
> > Are you suggesting to have a full copy of the table in MyISAM format?
>
> No, only the BLOB/TEXT columns need to be moved to MyISAM.
>
> >
> > Is there a
symbulos partners <[EMAIL PROTECTED]> wrote on 01/28/2005 11:14:00 AM:
> On Friday 28 Jan 2005 15:41, you wrote:
> > As you have noticed - you cannot.
> >
> > So, all you can do is creating a MyISAM table and copying
> > the column contents.
>
> Are you suggesting to have a full copy of the table
On Friday 28 Jan 2005 15:41, you wrote:
> As you have noticed - you cannot.
>
> So, all you can do is creating a MyISAM table and copying
> the column contents.
Are you suggesting to have a full copy of the table in MyISAM format?
Is there any other workaround? The reason because we are using Inn
Hello,
> I would need to index FULLTEXT two columns in a InnoDB table. How do you
solve
> the problem?
As you have noticed - you cannot.
So, all you can do is creating a MyISAM table and copying
the column contents.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase
Dear friends,
I would need to index FULLTEXT two columns in a InnoDB table. How do you solve
the problem?
--
symbulos partners
-.-
symbulos - ethical services for your organisation
http://www.symbulos.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscr
11 matches
Mail list logo
