Hi Paul
Have you run rscope on the data base it sound like a corruption in one of
the tables.
These are very large tables the most I have had is a 1.2 million rows
Victor
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of [EMAIL PROTECTED]
> Sent: Sunday, 25 August 2002 12:45 PM
> To: [EMAIL PROTECTED]
> Subject: Insert Problem
>
>
>
>
> I am having a problem with a 4.5++ database when doing
> inserts to tables.
> It started with workstation lock ups when inserting rows using
> "insert into
> ... select ...". Now when I am running an old program that
> inserts rows into
> a table, the process has slowed considerably. I recently did a pack and
> reload without a problem. However, there are several tables containing
> nearly a million rows and one with nearly 2.5 million rows. Any ideas?
>
> Paul Hill
> ================================================
> TO SEE MESSAGE POSTING GUIDELINES:
> Send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: INTRO rbase-l
> ================================================
> TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: UNSUBSCRIBE rbase-l
> ================================================
> TO SEARCH ARCHIVES:
> http://www.mail-archive.com/rbase-l%40sonetmail.com/
>
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
