Tim,

I tried to do (In EDBmngr) delete from test (1 million rows). I get the
error: #601 table corrupt (cannot find index page during retrieval from
cache). Then I did a repair. It claims to have repaired the table
succesfull. However trying to execyte the delete statement keeps generating
the error.

Any idea how to solve this (the table is too large to send).

Regards, Harry

Harry,

<< I tried to do (In EDBmngr) delete from test (1 million rows). I get the
error: #601 table corrupt (cannot find index page during retrieval from
cache). Then I did a repair. It claims to have repaired the table
succesfull. However trying to execyte the delete statement keeps generating
the error. >>

And this is build 5 you're using ?  This issue should have been corrected in
build 3 or 4.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim, just checked: indeed build 5


"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> schreef in bericht
news:084B17E5-870C-45BC-9BA6-D7AD00B282D8@news.elevatesoft.com...
> Harry,
>
> << I tried to do (In EDBmngr) delete from test (1 million rows). I get the
> error: #601 table corrupt (cannot find index page during retrieval from
> cache). Then I did a repair. It claims to have repaired the table
> succesfull. However trying to execyte the delete statement keeps
generating
>  the error. >>
>
> And this is build 5 you're using ?  This issue should have been corrected
in
> build 3 or 4.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
>

Harry,

<< Tim, just checked: indeed build 5 >>

Any chance of getting the code that you're using to create the table ?

Thanks,

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

I created the table in EDBmngr (field1 char (10) case-insensitive, field2
integer, field3 timestamp).
Then I used the SP you send me to add records in a loop (1 million).
Then I added on each field an index.

Regards, Harry



"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> schreef in bericht
news:0325B2B9-1C74-44CC-9E3C-84454E102D0F@news.elevatesoft.com...
> Harry,
>
> << Tim, just checked: indeed build 5 >>
>
> Any chance of getting the code that you're using to create the table ?
>
> Thanks,
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
>

Harry,

<< I created the table in EDBmngr (field1 char (10) case-insensitive, field2
integer, field3 timestamp). Then I used the SP you send me to add records in
a loop (1 million). Then I added on each field an index. >>

Duh, I should have figured that's what you did.  I'll let you know what
I find out this morning.

Thanks,

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

Did you find anything that causes it?

Regards, Harry


"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> schreef in bericht
news:BB68808E-94F5-4A77-BF8B-38A3AAEEEF92@news.elevatesoft.com...
> Harry,
>
> << I created the table in EDBmngr (field1 char (10) case-insensitive,
field2
> integer, field3 timestamp). Then I used the SP you send me to add records
in
> a loop (1 million). Then I added on each field an index. >>
>
> Duh, I should have figured that's what you did.  I'll let you know
what
> I find out this morning.
>
> Thanks,
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
>

Harry,

<< Did you find anything that causes it? >>

Yeah, stupid little error.  Build 6 will fix it.

BTW, let me know what your times are on the million deletes when you get
build 6.  I'm getting about 80 seconds on a P4 2.66 (no hyper-threading)
with the indexes still on the table.

--
Tim Young
Elevate Software
www.elevatesoft.com

80 Seconds for a million deletes on a "slower" P4....

I'm "sooooo...." disappointed...

Hopefully this will be faster on my 386 processor.

<grin>

Lance R



Tim Young [Elevate Software] wrote:
> Harry,
>
> << Did you find anything that causes it? >>
>
> Yeah, stupid little error.  Build 6 will fix it.
>
> BTW, let me know what your times are on the million deletes when you get
> build 6.  I'm getting about 80 seconds on a P4 2.66 (no hyper-threading)
> with the indexes still on the table.
>

Lance,

<< 80 Seconds for a million deletes on a "slower" P4....

I'm "sooooo...." disappointed...

Hopefully this will be faster on my 386 processor. >>



--
Tim Young
Elevate Software
www.elevatesoft.com