Problem creating metamorph indexes

Post by **Kai** » Fri Oct 17, 2003 9:34 am

Looks ok. What is full create-table statement used to create the tForms table (including all types and sizes)?

Your version of Texis uses the 32-bit API across the board, including file offsets, as indicated by the sole `-32' at the end of the version. It is thus limited to max 2GB tables (though with blobs you might reach 4GB because it's 2 files). Later versions of Texis for Windows -- with `-64-32' in the version -- still use the 32-bit API for memory etc., but use the 64-bit file API, and can thus create/access tables larger than 2GB.

kevin31 · Post by **kevin31** » Fri Oct 17, 2003 1:24 pm

Table creation is with this statement:
<sql db="$Updatedb" "CREATE TABLE tForms (FormID int, FormType int, TextBlob varchar(256))"></SQL>

In the scenario where index creation is failing the contents of the TextBlob sometimes approach 500 K. The total number of rows in the table is about 80000. Many rows contain small amounts of text.

kevin31 · Post by **kevin31** » Tue Oct 21, 2003 4:31 pm

Do you have any more thoughts on this issue? Is there anything else I can try?

Post by **Kai** » Wed Oct 22, 2003 10:10 am

That KDBF error when indexmem is 5 is suspicious; what amount of free space does dir report on that directory? Check for and delete any old Tnnn* files left over from previous failed index builds.