To insert a table of large amounts of data is slow, delete after index, speed faster, but the query and slow, statement to insert/* + append */into tablename nologging, to write every day tens of thousands of records, and real-time query to the table

CodePudding user response:

Insert before delete indexes rebuilt after inserting data index

CodePudding user response:

How about use a trigger to solve

CodePudding user response:

Article every day, tens of thousands of data, should pay attention to the building Lord, data is one-time article written by tens of thousands of, or a written one,

CodePudding user response:

reference 3 floor selling fruit net reply:

article every day, tens of thousands of data, should pay attention to the building Lord, data is written once tens of thousands of article, or a written one,

disposable wrote it

CodePudding user response:

Through the insert... The select,

Or insert select 1 from dual union all select 2 from dual union all... Select the from dual 10000?

CodePudding user response:

reference 5 floor selling fruit net reply:

by insert... The select,

Or insert select 1 from dual union all select 2 from dual union all... Select the from dual 10000?

written by the former

CodePudding user response:

Well,

1 # 1, consult the suggestion that lock table more troublesome,

2, consider the partition table, see whether to use on this form you,

CodePudding user response:

I don't think to want to consider the business scenario, the data is written by who, when written to, have time requirements,

Characteristic index table, itself is fast query, write slowly,

If insertion time allowed to test the following time consumption,

Alter index index_name very often;
Insert data
alter index index_name rebuild;

CodePudding user response:

references to regain CSDN eighth floor response:

I think should first consider the business scenario, the data is written by who, when written to, have time requirements,

Characteristic index table, itself is fast query, write slowly,

If insertion time allowed to test the following time consumption,

Alter index index_name very often;
Insert data
alter index index_name rebuild;

thank you thank you, I see under test

CodePudding user response:

references 9 f select_update_insert response:

Quote: refer to the eighth floor regain CSDN response:

I don't think to want to consider the business scenario, the data is written by who, when written to, have time requirements,

Characteristic index table, itself is fast query, write slowly,

If insertion time allowed to test the following time consumption,

Alter index index_name very often;
Insert data
alter index index_name rebuild;

thank you thank you, I am under test to see

tested, insert need to half an hour before, now only need half a minute, is to rebuild the index can also slow, it took 12 minutes