Tim

I thought I'd get some idea of file sizes and times by adding some additional text indices. Added (T1   _WhoFrom, T2  _WhoTo  ,T3 _Headers).

File size increased from 267Mb to 380Mb but when I tried deleting I received an error. Tried repairing the table (35 mins) and got the same error.


You have the tables on dvd

delete from mandn where _boxno = 17

================================================================================
SQL Error (ElevateDB 1.02 Build 1)
================================================================================

ElevateDB Error #601 The table MandN is corrupt (Cannot find index page during
retrieval from cache)

Roy Lambert

Roy,

<< I thought I'd get some idea of file sizes and times by adding some
additional text indices. Added (T1 _WhoFrom, T2 _WhoTo ,T3 _Headers).

File size increased from 267Mb to 380Mb but when I tried deleting I
received an error. Tried repairing the table (35 mins) and got the same
error. >>

It's the same error that you reported with the import.  A fix will be in
1.03.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


>It's the same error that you reported with the import. A fix will be in
>1.03.

Don't you wish code would do what you want the first time you asked

Roy Lambert