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

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

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