|Subject||RE: Insert into Large Table is slowly!|
>Do you use Classic or SuperServer? Version?
my server run in win2003，FB2.1，SuperServer
>How many cached pages? If you use Classic try increasing page buffers to 2000 and try again.
The Page size is 16KB, buffers is 51200.
>Let me know the results, thanks.
Thanks, I will try use GLOBAL TEMPORARY and INACTIVE index.
--- In email@example.com, <fabiano@...> wrote:
Do you use Classic or SuperServer? Version?
How many cached pages? If you use Classic try increasing page buffers to 2000 and try again.
Let me know the results, thanks.
--- In firstname.lastname@example.org, <email@example.com> wrote:
Hello, every body!
I have a 180GB database. and have a large table in it.
table's DDL is:
Create Table Table1
Create Index idx_Table1 on(f_MeterID, f_CMDID, f_Time)
about 50,000 rows be inserted every hour.
about 1.2 millions rows be inserted every day.
about 500 millions rows every year.
CREATE GLOBAL TEMPORARY TableTemp (
) ON COMMIT DELETE ROWS;
ALTE R INDEX idx_Table1 INACTIVE;
I insert data use follow:
1. start a transaction
2. Insert a batch records into temp table TableTemp, It's structure like table1
3. Insert into Table1 select * from TableTemp
Delete Data From TableTemp
(about 30,000 record every tiime)
USE GLOBAL TEMPORARY
4. commit transaction
ALTER INDEX idx_Table1 ACTIVE
but now, insert data become very slowly.
What should I do?