Subject | RE: [ib-support] %100 CPU usage with interbase, is it usual? |
---|---|
Author | KURSAT TASKIN |
Post date | 2001-12-28T15:28:44Z |
How are you importing data into the GDB?
When you import it using extrenal tables, IB will run this import in a
priority-thread and therefore using pretty much power as it can get.
Kursat: I am not using external table, I am inserting 1.000.000 record one
by one with a while loop
If you import data using other mechanisms, be sure to disable all indizes
you can to speed up import. Keeping the indizes active will require much
processing power for every insert and thus killing your machine. WIth
disabled indizes, import will be _much_ faster and the CPU will lock up only
for the time rebuilding the index, which should be not as long as the
importing itself.
Kursat: I do not have any index (if I understood the word "indizes" your
wrote, if it is another thing can you explain because I do not know)
I do not know another way to import data, also I can not do this with
external file because my fields do not have fixed with.
thanks alot
kursat
When you import it using extrenal tables, IB will run this import in a
priority-thread and therefore using pretty much power as it can get.
Kursat: I am not using external table, I am inserting 1.000.000 record one
by one with a while loop
If you import data using other mechanisms, be sure to disable all indizes
you can to speed up import. Keeping the indizes active will require much
processing power for every insert and thus killing your machine. WIth
disabled indizes, import will be _much_ faster and the CPU will lock up only
for the time rebuilding the index, which should be not as long as the
importing itself.
Kursat: I do not have any index (if I understood the word "indizes" your
wrote, if it is another thing can you explain because I do not know)
I do not know another way to import data, also I can not do this with
external file because my fields do not have fixed with.
thanks alot
kursat