Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread CREATE TEXT INDEX SQL for DBISAM
Mon, Mar 10 2014 4:50 PMPermanent Link

Markus Gnam

Hello Tim,

may it be possible to add CREATE TEXT INDEX (...) for DBISAM like ElevateDB with no need to alter the table?
I assume this could improve the full text index generation speed compared to "ALTER TABLE <tablename> TEXT INDEX (...)".

Best wishes,
Markus
Mon, Mar 10 2014 7:48 PMPermanent Link

Raul

Globestar Systems

Team Elevate Team Elevate

On 3/10/2014 4:50 PM, Markus Gnam wrote:
> may it be possible to add CREATE TEXT INDEX (...) for DBISAM like ElevateDB with no need to alter the table?
> I assume this could improve the full text index generation speed compared to "ALTER TABLE <tablename> TEXT INDEX (...)".

Not sure but issue might be that in DBISAM there is no catalogue so
anything table related is actually part of the table itself so whatever
we call itself is there would be a need to alter the table.

Raul
Wed, Mar 19 2014 10:03 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Markus,

<< may it be possible to add CREATE TEXT INDEX (...) for DBISAM like
ElevateDB with no need to alter the table?
I assume this could improve the full text index generation speed compared to
"ALTER TABLE <tablename> TEXT INDEX (...)". >>

The table alteration code in DBISAM is smart enough to know that only the
text index has changed, and that it only needs to update it, and not the
rest of the table.

Tim Young
Elevate Software
www.elevatesoft.com
Image