Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 3 of 3 total

Mon, Mar 10 2014 4:50 PM	Permanent 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 PM	Permanent Link
Raul 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 AM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. 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