Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Public Beta Tests » View Thread |
Messages 1 to 10 of 10 total |
corrupt table |
Thu, Jan 11 2007 7:09 AM | Permanent Link |
"Harry de Boer" | 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 |
Thu, Jan 11 2007 8:31 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@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 |
Thu, Jan 11 2007 8:57 AM | Permanent Link |
"Harry de Boer" | 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 > > |
Thu, Jan 11 2007 7:58 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@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 |
Fri, Jan 12 2007 3:25 AM | Permanent Link |
"Harry de Boer" | 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 > > |
Fri, Jan 12 2007 5:52 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@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 |
Mon, Jan 15 2007 5:07 AM | Permanent Link |
"Harry de Boer" | 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 > > |
Mon, Jan 15 2007 6:55 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@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 |
Tue, Jan 16 2007 2:50 PM | Permanent Link |
"Lance R." | 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. > |
Wed, Jan 17 2007 9:53 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Wednesday, June 12, 2024 at 01:54 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |